I created a table that syncs with two different google calendars (mine and person2). This table is then linked to our contacts table to have a history of the meetings we’ve had with each contact. There are times where both myself and person2 will meet with a contact and these instances are creating separate records in the meetings table and then both records are being linked to the contact.
How can I avoid this duplication? I thought that I could use an automation to search when a new record is created for another record where the google calendar ID is matches the new record but the airtable ID doesn’t. After that, I was planning on creating a script to delete the found record. However, because this is a synced table, I wondered if this would simply end up running infinitely because the event will attempt to sync each time Airtable sees that there is no record for the event and then the automation would delete it, rinse and repeat.