Skip to main content

Unique ID field

Give every record a number that counts up automatically. Add a prefix, a suffix, and a minimum length, such as INV-00001.

Written by Leo

A Unique ID field generates a unique, automatically incremented number for each record. It's meant to help you refer to a record by a short number, such as an invoice or a ticket number.

The unique ID field Property ID showing PROP-0008 below the property name in a record

Note:

  • People can't edit a unique ID. Tape fills it in when the record is created.

  • The number belongs to the database app. Every database counts its own records.

Who can use the unique ID field?

  • The unique ID field is available on all plans: Free, Plus, and Premium. See what each plan includes on our pricing page.

  • To add or change a field, you need Full access to the database app and a desktop or tablet.

Add a unique ID field

  1. Open the database app, open the app menu, and select Customize record layout.

  2. Click + or type / in a text block.

  3. Under New field, select Unique ID. You can also type Uniq to find it.

  4. Click the drag handle (⋮⋮) of the new field and select Edit field.

Opening Customize record layout from the app menu, clicking + next to a field, typing Uniq, and clicking Unique ID under New field so the new field appears in the layout

Clicking the drag handle of the unique ID field Property ID in the layout editor and selecting Edit field

Unique ID settings

In Edit field, you can shape how the ID looks:

  • Prefix: text before the number. Enter it under Enter prefix….

  • Suffix: text after the number. Enter it under Enter suffix….

  • Minimum length: the number of digits. Shorter numbers are padded, so 4 can show as 00004.

The Edit field menu of the unique ID field Property ID with Minimum length 4, the Prefix PROP-, and the Suffix None

If there's no prefix or suffix, the menu shows None. To remove one, delete its text. With the prefix INV- and a minimum length of 5, the fourth record shows INV-00004.

In a record, a copy button with the tooltip Copy to clipboard copies the ID.

In Edit field display, Size makes the ID bigger (Default, Large, Extra large, or Extra extra large), and Wrap text lets a long ID continue on the next line. Learn more about field display →

Use the unique ID

FAQs

Can I change the number of a record?

No. A unique ID is filled in by Tape and can't be edited.

Do existing records get an ID when I add the field?

Yes. Tape numbers every record of a database app when it's created, so existing records show their number as soon as you add the field. The numbers follow the order in which the records were created.

Can I add a prefix?

Yes. Enter it under Prefix in Edit field, for example INV-.

Can I have more than one unique ID field?

Yes, you can add more than one Unique ID field. They all show the same number of the record, so use them to show it in different formats, for example with and without a prefix.

Will a deleted record's number be reused?

No. The counter of a database app only goes up, so a number is never given to another record. That's why the numbers can have gaps, for example after you delete a record.

Are there other field types?

Yes! Database apps have fields for text, numbers, dates, members, files, relations, calculations, and more. See every field type in Intro to fields →

Still have more questions? Find answers and get help from community experts in the Tape community →.

Did this answer your question?