Help

Unique Value in booking system - booking #

Topic Labels: Admin Formulas
685 1
cancel
Showing results for 
Search instead for 
Did you mean: 
NLR_SPA_Yukon
4 - Data Explorer
4 - Data Explorer

I import data into a table, and one of the fields is a booking number, which is unique.

How can I make this field unique, that the import doesn't import the same ID including all the other data several times?

 

Thank you,

1 Reply 1
Vic_Airtable
Community Manager
Community Manager

Hi there!


The CSV import extension will allow you to merge data from your import file to existing records in your base in order to prevent duplicate entries. However, if your file has duplicate entries within it (for example, five rows all with the same booking number), this will not be recognized via the merge feature as it only looks to records within your base to match against. To get around this, feel free to import the data and then use the dedupe extension to find and merge the duplicate records.

 

Hope this helps point you in the right direction!