My team is looking to be able to reference tasks with a unique identifier (other than the name which isn't guaranteed to be unique). The Notion database id returned with id() isn't very user friendly. I'm looking for a formula or alternative method to auto-generate a more user-friendly but unique identifier for each task.
Connect
1 Answer
Ok, you can try this:
slice(replaceAll(format(id()), "[0-9]*", ""), 0, 4) + "." + slice(replaceAll(format(id()), "[0-9]*", ""), 4, 8)
It won't be always unique, but might be enough for your case.
You can check if its ok for your database comparing "count unique values" for this formula column with "count all" for any other.
If not, try to use combination with name, smth like:
prop("Name")+"."+slice(replaceAll(format(id()), "[0-9]*", ""), 0, 4)
Related questions
Without Answer
-
- 335
- 0
- Apr 29
-
- 1287
- 1
- Apr 4
-
- 413
- 1
- Mar 20
-
- 417
- 0
- Mar 14
-
- 360
- 0
- Feb 21
-
- 342
- 1
- Feb 14
-
- 424
- 0
- Feb 13
-
- 423
- 0
- Feb 11
- see all
Recent Activities
joeythelemur commented Apr 29
How can I better organize a LOT of properties?amandabee selected an answer Apr 29
Adding a basic feedback form to pages in a Notion…amandabee answered Apr 29
In Notion, I want the “Title” column to be filled …amandabee answered Apr 29
How can I better organize a LOT of properties?
...