I’m setting up a project management/crm database and I need to create a series of nested tables like this:
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!