Creating Custom ID using the No ID property with Notion Automation

Just sharing a formula/automation since no easy answer came up when I was googling.

To create an ID with a format like "PROJ-2026-xxx" where xxx is an incremental number:

• make sure the database has the dedicated "ID" property as a column

• create your text type column "PROJ ID" or whatever you want to call it. It CANNOT be the Name property because of how automations work.

• start a Notion Automation with trigger "Page Created"

• use the following formula: "PROJ-"+formatDate(Date triggered,"YYYY")+"-"+padStart(format(Trigger page. No ID),3,"0")

  • Date triggered is a property you can select, same with Trigger page
  • You might have to select "No ID" from the available properties, also delete the space after the . after Trigger page, I just had to add it so I didn't create a link to nothing

• replace PROJ with your acronym of choice

Known decifiency: future years will not start back at 001. Because it is the row ID it will always increment. i.e PROJ-2026-045 will be followed by PRJ-2027-046. As far as I know the only way to restart incrementing would be to do this automation with an external service (yuck!)