New records are numbered by a script. I created and deleted blank records. How can I restore those numbered records?

While creating a record at work, e.g. Q#1640, I kept making new records (#1641-1645) clumsily and deleting them. Unfortunately now the business is missing those rows. There’s no field to leave a comment. Is it possible to add, paste, or restore rows #1641-1645, and have the table working normally?

You categorized this as “Formulas” but mention a script doing the numbering, which is it?

If its a script, is it a Scripting app, or a Script Action in an Automation?

Welcome to the Airtable community!

Is is possible that you are using an autonumber field as part of your numbering? If so, it is not possible to go back and have the autonumber field fill in previous values that were deleted. There are some work arounds that involve using a mix of autonumber and formula fields. If you don’t need to keep existing numbers, it is also possible to redo autonumbering, throwing out all existing numbers and starting over. Often neither of the workarounds fit, though.

Another possibility is to reconsider whether or not it is really necessary to include the missing numbers. The missing numbers can feel wrong from a spreadsheet point of view, but often a database can function just fine without the missing numbers.

This topic was solved and automatically closed 15 days after the last reply. New replies are no longer allowed.