Task IDs (Notion)
How to implement something like task IDs or card IDs in Notion, similar to Trello - Card-IDs (Trello)?
There seems to be no out-of-the-box solution, but there is a global ID for each entity.
Additionally, there are some workarounds that seem quite convoluted
Overview
Approaches to create task- od card IDs:
- Manual
- Global IDs
- Notionthings.com: Create real IDs, from Global IDs + joined table
- Datestamp-IDs: Create IDs based on creation datestamps of objects
- NotionPlusID
- API ?
Manual
Just add a field Task-ID or Card-ID and give it manually a number, when needed.
GlobalIDs
Rows of database tables do have a global ID. They can be retrieved with the function id(). They are quite long and unwieldly, like cef53e69b99d426f8ad5a00bd9f6e5f3.
Notionthings.com
Solution here from Notionthings.com. I think it's as impressive as it may be convoluted.
How it seems to work:
- Create a database table used for ids only - id table
- Relate a database table that needs IDs to this table
- In the main table, have a rollup function that copies the
id()value from the id table - Do some rollup stuff back-and-forth between these tables, that eventually count the number of commas that separate those ids
- Use that count +1 as the id for the next row.
Let's see if there are easier solutions.
Sources:
- https://notionthings.com/2022/03/06/auto-increment-table-row-ids
- https://www.reddit.com/r/Notion/comments/v3ivmr/comment/ibkpcnq
Datestamp IDs
Approach: Use the dates