I’m using airtable as a contact database (currently 450 records). This database needs to be mass updated by exported information once a month. Is there a way to mass lookup the differences in one set of data and update the old data with the most recent information? I know you can use Zapier to do this, but it is super expensive. Any tips?
We are also wanting to track progress for each contact. For example;
John smith is a record that has not taken a course so on his record the course is marked as “No”. Once he takes the course we want to update his record but also see that it was marked as “No” on a certain date. Would love help figuring this one out. Thanks!
No, I don’t. There is no real quick or easy or automated way to do the things that you listed, so they would need to be manually programmed into your system.
Also, these sound like pretty large tasks that you need to accomplish, so it’s likely that you might need to hire a consultant to help you with these tasks.