Create new database item with @today value

[lmmartin]

Hi, I’m creating a new workflow to generate my company daily meeting notes and send it to slack.

I need to create it with the title @today (relative date that notion handles), but I can’t do it.

Other option could be create database item using an existing template, but I don’t know if that’s possible.

Anyone handled anything like this?

Thanks in advance

[EmeraldHerald]

Hi @lmmartin Welcome to the community

While I’m not so sure the node supports this from my testing, it does look like their API supports it. An example JSON request would look like this:

{
  "type": "mention",
  "mention": {
    "type": "template_mention",
    "template_mention": {
      "type": "template_mention_date",
      "template_mention_date": "today"
    }
  },
  "annotations": {
    "bold": false,
    "italic": false,
    "strikethrough": false,
    "underline": false,
    "code": false,
    "color": "default"
  },
  "plain_text": "@Today",
  "href": null
}

You could use a HTTP Request node to make a custom request for this, instead

[lmmartin]

Hi @EmeraldHerald. Thanks for your help,

I tried to use template_mention in title, but notion api retrieves me an error: Template mentions cannot be created outside of templates.

But thanks to your idea, I tried this title info:

{
    "type": "mention",
    "mention": {
        "type": "date",
        "date": {
            "start": "2023-08-03",
            "end": null,
            "time_zone": null
        }
    },
    "annotations": {
        "bold": false,
        "italic": false,
        "strikethrough": false,
        "underline": false,
        "code": false,
        "color": "default"
    },
    "plain_text": "Today",
    "href": null
}

With this solution the title not showing today, yesterday, etc, but it’s linked to the date (for example: August 6, 2023) that it works for me.

Thank you!

[EmeraldHerald]

@lmmartin I’m so glad you were able to get this working!

By the way, it may be worth creating a thread in our Feature Request section to get our product team’s eyes on possibly adding this functionality to the node