Nested Tables and Circular Reference Errors


#1

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

Thanks!
-Donald


#2

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