To the best of my knowledge, you can only achieve this by running an automation that executes a script (requires some javascript knowledge). If you'd like assistance with this feel free to PM me.
If anyone can provide an alternate method I'd love to hear it as that would simply a few functions in some of my bases. 😂
you could probably do this either through an automation, formula, or using linked records depending on your setup. can you explain the base a bit more and end goal? could a given account name have multiple records on a given day? do you need to account for different time zones? depending on the need you may just be able to use recordIDs
There is an 'autonumber' field in airtable as well, but just be cautious that if you delete a record it's static so it won't update (e.g. if you have 1, 2, 3, and then delete row with 2, then you'll have 1, 3 left)
you could probably do this either through an automation, formula, or using linked records depending on your setup. can you explain the base a bit more and end goal? could a given account name have multiple records on a given day? do you need to account for different time zones? depending on the need you may just be able to use recordIDs
There is an 'autonumber' field in airtable as well, but just be cautious that if you delete a record it's static so it won't update (e.g. if you have 1, 2, 3, and then delete row with 2, then you'll have 1, 3 left)
Thank you for your quick response.
Yes, this table expands on a different table's work orders. So this table is essentially the other table's work order's line items. So yes, a given account name would have multiple records on a given day. I would like to have the records numbered 1,2,3,4... when the account name and created date are the same. Everything is in the same time zone. The time does not need to match, just the date. I was then planning to incorporate the 1,2,3,4... into the primary field's name through a formula.