Auto-Generate IDs

​

Overview

​

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 byEdit field.

2

Use Autonumber

Choose the Autonumber field type.

Autonumber fields assign simple numbers starting from 1. For more control over how your IDs look, read on.

That’s it! A number will now be generated for each row, whether existing or new.

​

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

+ Add field and select Formula.You can read more about formulas here.

3

Input formula

Enter a Title or column name, followed by your Formula. Then, click Create.That’s it! A custom number will now be generated for both new and existing records.

​

Related articles