I am hoping to get some advice on what to do in the following scenario:
I have a base created from form entries. I want to add a column to this base to reflect a 'customer_id' that I have separately in an external csv. I cannot import this data to match it within Airtable as it has ~600k rows. I want to match the name and DOB given by the forms in the base in Airtable with the same values in my customer_id dataframe in order to import the customer_id as a new column in my Airtable base. Any tips on the most effective and efficient way to do this, within Airtable as much as possible, would be greatly appreciated! But if there are any integration suggestions, let me know! Thank you 🙂
I see that you can do something similar to what I am asking using the CSV import extension... however this has a 25k row limit which is problematic for my 600k customer dataframe.