Working with the UUID field

The UUID field automatically generates a globally unique 36-character ID for every row, perfect for use with external systems and APIs.

This guide covers what a UUID field is and why it’s used, how to add a UUID field to your table, and the key differences between a UUID and an Autonumber field.

Learn more: Configure field types

UUID field

What is a UUID field?

A UUID (Universally Unique Identifier) field is an automatic field that generates a unique 36-character string (e.g., a1b2c3d4-e5f6-7890-g1h2-i3j4k5l6m7n8) for every new row.

The two key properties of this field are:

  • Non-editable: Users cannot manually change the value, ensuring data integrity.
  • Globally unique: The generated ID is statistically guaranteed to be unique across all tables and all databases, not just within its own table.

This makes it the perfect choice for a primary field when you need a stable, unique ID for use with APIs, external integrations, or when merging data from different sources.

How to add a UUID field

  1. In your table, click the plus sign + to add a new field.
  2. Select UUID from the field type dropdown menu.
  3. Name the field (e.g., “Unique ID”).
  4. Click Create.

The field will automatically populate for all existing rows and any new rows you create.

Frequently asked questions

What’s the difference between a UUID and an Autonumber field?

While both fields create unique IDs, they serve different purposes:

  • Autonumber field: Creates a simple, human-readable, incrementing number (1, 2, 3…). It is only unique within its own table. Use it for simple internal references.
  • UUID field: Creates a complex, 36-character machine-readable string. It is globally unique. Use it when you need a permanent ID for external systems, APIs, or merging databases.

Can I edit a UUID value?

No. The field is non-editable to guarantee its uniqueness and integrity as a permanent record identifier.

Can I use a UUID as a primary field?

Yes. It is an excellent choice for a primary field, especially if you plan to access your data via the API or from other applications.

Related content

Still need help? If you’re looking for something else, please feel free to make recommendations or ask us questions; we’re ready to assist you.