I am using AirTable for a Customer Service Inquiry tracking database.
I want to be able to enter each “Case” (a record or row) into an AirTable base and for it to be given a “Case #” that is +1 from the highest number listed in the Primary Field column (column 1).
The challenge is that I have over 1000 records in the base and these records do not start at 1 and there are gaps in the list here and there as well.
I have tried using autonumber and have messed around with zapier with no luck. I am hopeful that someone in this community has figured out an elegant solution to this problem.
I want a formula or zap or something that when a new record is created, the first thing that happens is that the primary field is given a new record number that is +1 from the highest number found in this primary field (column 1).