- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Jan 13, 2025 11:00 AM
I am fairly new to airtable and have gone back and forth on whether this is an automation or a formula.
I would like to create a field where when two conditions are met, it auto numbers.
For example, when records have the same "created date" and "account name" this field would auto-number. If there are no records with matching "created date" and "account name" then it would auto-number to 1.
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Jan 13, 2025 11:16 AM
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. 😂
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Jan 13, 2025 11:16 AM
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)
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Jan 13, 2025 11:28 AM
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.
