Jul 16, 2020 02:48 PM
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!
Jul 16, 2020 03:59 PM
You can also do this with Integromat, which is much cheaper than Zapier. And it has way more power & functionality than Zapier, too.
Jul 17, 2020 09:59 AM
I cannot figure out how. Do you have a step by step for something like this?
Jul 17, 2020 10:45 AM
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.