Help

Airtable Cobuilder is here! Learn more about our new no-code app creation feature, powered by AI on the Airtable Academy

Reset the row # when using autonumber and formulas

Topic Labels: Base design
Solved
Jump to Solution
3681 2
cancel
Showing results for 
Search instead for 
Did you mean: 
Dave_Case
4 - Data Explorer
4 - Data Explorer

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?

1 Solution

Accepted Solutions
Justin_Barrett
18 - Pluto
18 - Pluto

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.

See Solution in Thread

2 Replies 2
Justin_Barrett
18 - Pluto
18 - Pluto

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.

Excellent! Thank you for the help!