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
-
- 230
- 0
- May 19
-
- 115
- 0
- May 16
-
- 502
- 0
- Apr 29
-
- 464
- 1
- Mar 20
-
- 473
- 0
- Mar 14
-
- 418
- 0
- Feb 21
-
- 408
- 1
- Feb 14
-
- 474
- 0
- Feb 13
- see all
Recent Activities
amandabee asked May 16
Display backlinks in a block or page?amandabee answered May 15
Counting Stars?polle answered May 14
Counting Stars?amandabee answered May 13
settings of font colour changed?
...