Help

How to create a unique value constraint on a Particular field of Airtable

Topic Labels: Automations
1836 2
cancel
Showing results for 
Search instead for 
Did you mean: 
Binal_Patel
4 - Data Explorer
4 - Data Explorer

Hi,

I have a table created Sign in - Airtable named “Event Register”.

This table has one field named “Event” which is of type “Link to Another Record”. How can we set up any constraint on this field so that it should always have a unique value? Can we use any scripting action here?

Can we show an alert or pop-up to the user on entering the duplicate value?

2 Replies 2
Jono_Prest
6 - Interface Innovator
6 - Interface Innovator

Hi @Binal_Patel,

To be clear - are you wanting to check if the linked record has not been linked to any other record in the “Event” table? Or do you want the name of the linked record to be a unique value (but still be available to be linked to multiple “Event” records)?

The latter is easy to solve by appending a unique identifier such as the record id or the value of an auto-number field to a descriptive name using a formula field as your primary field. This would ensure no two records in that table have the same primary key. For example use a formula like this as your primary field and combine two other fields:

{record name} & "-" & {autonumber field name}

The former is a little more complex to solve but can be done using an automation script that is triggered on a change to your linked field. This would require some scripting knowledge.

You can set up a view that will filter out anyone who has already registered. Then limit registration to that view.