Skip to main content
All CollectionsWhat's New
Generated Column Types
Generated Column Types

Add a unique identifier or reference number to your data with Generated column types.

Erica Chappell avatar
Written by Erica Chappell
Updated over 6 months ago

Create a Generated column to effortlessly add a unique identifier or reference number to your data.

How to add a Generated column

To add as a new column directly to a table:

  1. Click the + sign in the last column of the table

  2. Choose Generated from the type dropdown

  3. Determine which Generated column type to use

  4. Configure the variables and characters you would like your format to be

  5. Toggle on Require Uniqueness if this will be used as a unique ID and the outcome should be unique for your account

To add as a new column inside the record details, click the Configure Data button at the bottom and repeat the steps above.

Generated Column Types

Set your desired format from the following options to auto-generate an ID:

  • Text - creates a letters-based ID (e.g. “******” = “AAAAAA”)

  • Incremental - creates a numbers-based ID (e.g. “######” = “000000”)

  • Random - creates an ID of letters and numbers (e.g. “###**#” = “000AA0”)

Go to TeamBridge

Have feedback on the Generated column types, want to request a new feature, or spotted a bug? Let us know on our Canny!

Did this answer your question?