Base sync

Hm, sounds like you’re either:

1. Exceeding the 10k select options for a single select / multi select field
2. Exceeding the 1k options that a record can have selected for a multi select field

And so if I were you I’d go through the single select / multi select fields in the base and look for either of these issues and fix them

For the first issue, this would involve either deleting existing options that aren’t in use anymore, or converting the field into a text field

For the second issue, I think converting it to a text field would be the only option I’m afraid

​@dpeacock 

You have gone over the limit for options in your single-select or multi-select field.

You have 2 different ways of fixing this:

• You can switch that field to a linked record field, but then you will need to be cautious of not exceeding the limit for records in your base.
• You can switch that field to a normal text field, as mentioned above by ​@TheTimeSavingCo

However, one very important thing to note is that most people do not use that “emailed CSV” option which creates a CSV sync table in your base.

That’s because it comes with some serious & major limitations:

1. You can’t delete any records from that table.
2. You can’t add any records to that table.
3. You can’t edit any records in that table. (You can add extra fields which are editable, but you can’t edit any of the original fields that were synced.)

Your much better & much more powerful way of importing CSV files into Airtable is to use Make’s CSV tools.

Using Make will create a NORMAL TABLE in Airtable (not a sync table), which you have full control over.

You can add records, edit records, and delete records — just like any normal table.

I give step-by-step instructions on how to import CSV files into Airtable with Make on this Airtable podcast episode.

And, if you’ve never used Make before, I’ve assembled a bunch of additional Make training resources in this thread.

Hope this helps!

If you’d like to hire the best Airtable consultant to help you with anything Airtable-related, please feel free to contact me through my website: Airtable consultant — ScottWorld

Thanks Everyone for the guidance, this helped me alot.