Is it possible to renumber records from 1?
Records are automatically numbered in the order that they are added.
Record numbers are not updated once they are assigned.
In the cases where you need to renumber records from '1' (e.g., in the cases when you have deleted some records), follow the steps described below.
Create a new app by copying (duplicating) an existing app.
Export record data of the source app to a CSV file.
Import the CSV file to the app created in step 1.
You need to uncheck the "Key to Bulk Update" check box for the Record number when importing the data.
Records are bulk copied to the new app and renumbered from '1'.