Hi Everyone, I duplicated a base which I’ve done many times, but this time entries from the associated form did not start at 1. Is there anyway to edit the existing entry IDs if the form is still open/accepting submissions? Essentially I want to edit the current entry IDs so that they go from 1 and increase in numerical ,order, then have the future entries follow that order.
Thank you.
Best answer by Kamille_Parks11
“Entry ID” is not an Airtable term, that is a name given to a field (presumably) in your base. Keep things like this in mind for future threads as we’ll have to guess what you mean.
From context, it sounds like you’re talking about a field named {Entry ID} that has the field type of Autonumber. To reset an Autonumber field’s numbering, convert the field into any other type, then convert it back to an Autonumber. Do this by rightclicking the name of the field and hitting “Edit field” or “Configure options”.
Airtable will renumber all records from 1 to [n] based on the order the records appear in the View you’re looking at. Make sure when you do this, your records are sorted so that they are in the sequence you want them numbered.
+27“Entry ID” is not an Airtable term, that is a name given to a field (presumably) in your base. Keep things like this in mind for future threads as we’ll have to guess what you mean.
From context, it sounds like you’re talking about a field named {Entry ID} that has the field type of Autonumber. To reset an Autonumber field’s numbering, convert the field into any other type, then convert it back to an Autonumber. Do this by rightclicking the name of the field and hitting “Edit field” or “Configure options”.
Airtable will renumber all records from 1 to [n] based on the order the records appear in the View you’re looking at. Make sure when you do this, your records are sorted so that they are in the sequence you want them numbered.
“Entry ID” is not an Airtable term, that is a name given to a field (presumably) in your base. Keep things like this in mind for future threads as we’ll have to guess what you mean.
From context, it sounds like you’re talking about a field named {Entry ID} that has the field type of Autonumber. To reset an Autonumber field’s numbering, convert the field into any other type, then convert it back to an Autonumber. Do this by rightclicking the name of the field and hitting “Edit field” or “Configure options”.
Airtable will renumber all records from 1 to [n] based on the order the records appear in the View you’re looking at. Make sure when you do this, your records are sorted so that they are in the sequence you want them numbered.
Thanks so much for the reply and clarity/insight for futures post. I appreciate the feedback. Your instructions were clear and my base is updated. Thank you.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.