They’ll stay linked as long as you don’t delete the items that they’re linked to.
You can’t delete an item and then recreate it… that will break the link.
So, when you import your CSV, be sure to “merge” (or “upsert”) the new records with the old records.
You can do this with Airtable’s CSV Import app, which gives you the ability to “merge“.
However, Airtable’s CSV app can’t be automated at all.
If you’d like to automate the process of importing & merging CSV files into Airtable, then you would want to use Make’s CSV modules along with Make’s Airtable modules.
Make’s Airtable modules lets you “upsert” records, which is the same thing as “merging”.
I demonstrate how to import & merge CSV files using Make on this Airtable podcast episode.
Hope this helps!
If you have a budget and you’d like to hire the best Airtable consultant to help you with this or anything else that is Airtable-related, please feel free to contact me through my website: Airtable consultant — ScottWorld
Updating a library base won’t usually break linked records, but changes to field names or structures can affect them. For easy explanations on such cases, I often check resources like paintlogs.
Not true. Changes to field names will not break linked records. Changes to structures will not affect linked records (unless you break the linked record structure itself). And paintlogs has nothing to do with Airtable.
- ScottWorld, Expert Airtable Consultant
Actually, linked records in Airtable don’t break just because of field name or general structure changes. They remain stable unless the actual linked record setup itself is altered or removed. So renaming fields or adjusting other table elements won’t affect the linked connection.
