I use proprietary software in my line of work that allows me to export client data into a CSV file. One of the fields in this CSV file is called Household ID. Let’s call this CSV file “Household Assets”.
In airtable, I already have a table called “Households” with has the exact same Household ID field and number for each household.
Is there any way to import the CSV into its own table in airtable and automatically link both tables given they already have a common field, Household ID?
This would be useful as I could simply import once per month all my household asset updates and somehow track the trend and progress of my client assets.
Any ideas how I might be able to accomplish this? It would be great if I could even somehow automate this process too.