Hi, thanks for any help anyone can give, I feel like my head is going to explode.
Essentially what I’m attempting to do is have an autonumber generate based on the project it is linked to. I am tracking forms that come in from different projects within the same table.
I need it to work so that If a record is associated with ‘Project 1’ it will generate the next number associated with ‘Project 1’ and if I then create a record associated with Project 2 it won’t carry on from the number generated from the ‘Project 1’ recorded created.
I feel like im explaining this so badly, so if anyone needs further clarification I’m happy to give it. I’m an intermediate user concerning Airtable but this is just baffling me completely!
I’ve managed to get something similar to work by using the “Find records” automation to look for all the related records, for example “Project 1”, and then updating the field with that value
Your table already has two records associated with “Project 1”
You create a record associated with “Project 1”
The automation looks for all records associated with “Project 1” and finds 3 records
The automation updates the record that triggered the automation run with the number 3, which you can get via the
length value of the find result
You then create a record associated with “Project 2”
The automation searches for records associated with “Project 2”, and finds 1 record, i.e. the one that was just created
The automation updates the record that triggered the automation with the number 1
Let me know if you end up looking into this and have questions
A conditional autonumber is very achievable with two related tables and zero automation (no need for Pro). You can do this by rolling up the recordIDs (or a UNIX timestamp) of related records, and then searching for the position of that number within that related record. I have more details in the following post.