Hi,
I’m setting up a project management/crm database and I need to create a series of nested tables like this:
-Projects:
“001”
–Jobs:
“001-01”
—Quotes/Invoices:
“001-01_01”
----Tasks
"001-01T01"
-----Timesheets
"001-01T01-01"
…etc.
The last two decimals of a new record code should equal the highest value + 1 of it’s siblings.
My problem is that the only ways that I’ve seen in Airtable to find max or count for a group of records or an array all require a linked field, and if my operation changes the name of the primary field on my record, I get a circular reference error!
Can anyone suggest a workaround? Maybe I need to populate a static table of initial values and then turn it into an autonumbering machine…? Argh, I need to sleep! :slightly_smiling_face:
Thanks!
-Donald