What this tool does
The Unique ID Generator assigns formatted sequential IDs to records in your Airtable table. You control the starting number, padding, and how often the counter resets. Useful for creating order numbers, ticket IDs, invoice numbers, or any identifier that needs to be sequential and human-readable.Settings reference
Source
Counter settings
Handling
How IDs are formatted
The ID is the sequential number formatted with the configured zero-padding. Examples:- Padding 3, Start 1:
001,002,003 - Padding 4, Start 100:
0100,0101,0102 - Padding 1, Start 1:
1,2,3
Counter reset behavior
Resetting produces IDs like
001 for the first record each year or month.
Using the preview
The preview panel shows the IDs that would be generated for your records before you run. Use it to verify the format looks right.Common questions
Can I add a prefix or suffix to the ID?
Can I add a prefix or suffix to the ID?
The tool generates numeric IDs with padding. If you need a prefix like
INV-001, use the Text Processor tool to prepend INV- to the output field after generating the IDs, or use an Airtable formula field that concatenates your prefix with the generated number.What if two records get the same ID?
What if two records get the same ID?
The tool assigns IDs in the order records are fetched from Airtable. If you run the tool twice without “Skip already processed” and without filters, records could get reassigned IDs. Always enable “Skip records that already have an ID” to prevent overwrites.
Can I start from a number other than 1?
Can I start from a number other than 1?
Yes. Set Start number to any number. If your existing highest ID is
INV-042, set Start number to 43 to continue from there.