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.
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 accessto the database app and a desktop or tablet.
Add a unique ID field
Open the database app, open the app menu, and select
Customize record layout.Click
+or type/in a text block.Under
New field, selectUnique ID. You can also typeUniqto find it.Click the drag handle (
⋮⋮) of the new field and selectEdit field.
Unique ID settings
In Edit field, you can shape how the ID looks:
Prefix: text before the number. Enter it underEnter prefix….Suffix: text after the number. Enter it underEnter suffix….Minimum length: the number of digits. Shorter numbers are padded, so4can show as00004.
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
Use it as the primary field to title records with their number. Learn more about the primary field →
Use it in a calculation, for example to build a longer reference. Learn more about calculation syntax →
Use it in a view to sort records in the order they were created. Learn more about sorting views →
FAQs
Can I change the number of a record?
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?
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?
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?
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?
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?
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 →.
