Periodic imports with new import data -> compare changed data

Hi,
I am pondering for a while now how I can periodically import data from the same csv template style sheet and being able to compare the changes. Given the different import dates, the Index I would normally be using (Supplier ID) is useless as its not unique any longer if importing in one table. I also tried importing into separate tables for each import but that gets messy and I also did not find a way to compare changes. Once imported, I would like to show deleted and new data (suppliers) and show any changed data between those two import dates? I am new to Airtable: I have been using a more static platform before but finally give up finding work arounds :wink:

how about using Concatenation in the primary field to combine Supplier ID and import data to get a unique value?

You would typically need to have a unique identifier in both your CSV file and your Airtable table.

If you can get that setup, then you can use Airtable’s CSV extension to help you merge the new changes with the old data.

For an even more advanced way of doing this, you can use Make’s CSV tools and Make’s Airtable tools to do the merging. Make offers an “Upsert Record” module, which you can use to merge new changes with the old data.

I give step-by-step directions on how to do this on this BuiltOnAir podcast episode:

Thanks a lot Scott, I will try that. Funny enough that was the podcast via which I signed up to Tableforums :wink:
Back to topic: I was surprised that I cannot get the look up functionality to auto link all related fields, only by manually clicking the linked field.

1 Like

Ha, that’s amazing! :smiley:

Ah yes, that’s one of the unique things about Airtable that is different from other database systems — no automatic linking of records.

However, you can always create an automation to update your linked record field with whatever value you need to put in there.

And you can import data into your linked record fields, too… but only when using Airtable’s CSV Import Extension or using an API tool like Make.

1 Like