Help

The Community will be undergoing maintenance from Friday February 21 - Friday, February 28 and will be "read only" during this time. To learn more, check out our Announcements blog post.

Auto number based on two conditions

Topic Labels: Formulas
386 3
cancel
Showing results for 
Search instead for 
Did you mean: 
michellepfl
4 - Data Explorer
4 - Data Explorer

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. 

 

 

3 Replies 3
Kenneth_Raghuna
8 - Airtable Astronomer
8 - Airtable Astronomer

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. ðŸ˜‚

ibayub
6 - Interface Innovator
6 - Interface Innovator

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.