Nested Tables and Circular Reference Errors


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! :slight_smile:



Is there any way to find a max() or count() within a table? (Without using a table linked through the primary field?)