I am creating a Master Calendar & Team Calendar system in Airtable, where each calendar update automatically updates/creates based on an update in the other calendar.
I put together a system that created a “Unique Event ID”, which is a shared ID for the same event across both Bases. Everything is working great so far, except that I would like to delete records automatically in one Base if the corresponding record is not found in the other.
There’s no Delete trigger in Integromat, so my workaround is:
-The trigger is an existing “Update Record” automation
After that automation completes, the automation will do a scan on both Airtable Bases.
Step 1: Search all existing records on Master Calendar Base (up to 10,000)
Step 2: Search all existing records on Team Calendar (up to 10,000)
Step 3: Filter, then Delete - If the Event ID is found on the Master Calendar Version but does not exist on the Team Calendar Version, Delete the record on the Team Calendar (up to 10,000)
I’ve tried a few different versions of this scenario with no luck. The “Delete Record” function only seems to delete the first record found.
Has anybody attempted to do something like this before? Am I going about it the wrong way? Very much appreciated…