Save the date! Join us on October 16 for our Product Ops launch event. Register here.
Jul 15, 2020 07:26 PM
Hey all, new to AirTable!
So, I’ve setup a table which uses an Autonumber field in conjunction with formulas in two other fields to create an ID which will increment a base number (say, 10000 in this case) by the row number so whenever I create a new row, these two fields values will go 10001, 10002, etc…
So, it’s all working great, but when I delete the test rows, the autonumber doesn’t reset back to 1. I had to delete the field and re-create it to make it work - is there a better way?
Solved! Go to Solution.
Jul 15, 2020 08:07 PM
Welcome to the community, @Dave_Case! :grinning_face_with_big_eyes: Deleting the field isn’t necessary to reset it. You can change the field to another type like single line next, then change it back to autonumber, and it’ll start over from 1 again.
Jul 15, 2020 08:07 PM
Welcome to the community, @Dave_Case! :grinning_face_with_big_eyes: Deleting the field isn’t necessary to reset it. You can change the field to another type like single line next, then change it back to autonumber, and it’ll start over from 1 again.
Jul 16, 2020 06:15 AM
Excellent! Thank you for the help!