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
-
- 468
- 0
- Apr 29
-
- 428
- 1
- Mar 20
-
- 428
- 0
- Mar 14
-
- 380
- 0
- Feb 21
-
- 359
- 1
- Feb 14
-
- 436
- 0
- Feb 13
-
- 460
- 0
- Feb 11
-
- 418
- 1
- Feb 8
- see all
Recent Activities
amandabee answered 3 hours ago
Counting Stars?polle answered 1 day ago
Counting Stars?amandabee answered 1 day ago
settings of font colour changed?amandabee asked 1 day ago
Counting Stars?joeythelemur commented Apr 29
How can I better organize a LOT of properties?
...