Help

Upcoming database upgrades. Airtable functionality will be reduced for ~15 minutes at 06:00 UTC on Feb. 4 / 10:00 pm PT on Feb. 3. Learn more here

Comparing item with others in the column

Topic Labels: Formulas
280 1
cancel
Showing results for 
Search instead for 
Did you mean: 

I’d like the numbers in a numeric column to be unique. Is there a way to check with a formula whether the new entry already exists in the column, no matter how many items there are? The result can appear in the column itself if possible, or in an extra field like for errors.

I mean if there is a field with
1
2
3
…and I add a fourth item, which is
1
again
– it should not be possible or return a warning

1 Reply 1

A formula field cannot access other values in the same column; it can only access other values in the same record/row.

You can the summary bar to determine uniqueness. Note that this will only show uniqueness for the records in the view. The summary bar will not take into considerations any hidden records.

You can also use an autonumber field to guarantee uniqueness.