- Requires a linked parent database (in the example I'm creating new entries from a filtered view so the parent is automatically linked)
How it works:
- We roll up the long ID to the parent, then pass all of the long IDs back down to the children
- Since the long IDs are in sequential order, we strip off any characters in the string that fall after the long ID
- Then we replace all but "," characters and count how many there are. Add 1 and this is our auto-assigned ID
<aside>
💡 Tip: If you want to start with a higher number than “1”, edit the ID property and change the “+ 1” to the number of your choice.
</aside>
Master DB
Auto-Increment