Overview
For some use cases, generating unique record IDs can be helpful when keeping track of data or exporting it for external use.Common use cases
- Invoices: Easily assign and reference invoice numbers when billing clients
- Data exports: Maintain consistent identifiers across systems
- Internal tracking: Quickly reference specific records without confusion
How to create unique record IDs
1
Create or edit field
In your database, create a new column or hover over an existing column and click followed by
Edit field.
2
Use Autonumber
Choose the 
That’s it! A number will now be generated for each row, whether existing or new.
Autonumber field type.
Autonumber fields assign simple numbers starting from 1. For more control over how your IDs look, read on.

How to create custom unique record IDs
1
Start with an Autonumber column
Follow the steps above. You can hide this field from view.
2
Add a Formula column
3
Input formula
Enter a Title or column name, followed by your Formula. Then, click 
That’s it! A custom number will now be generated for both new and existing records.
Create.

