Hey folks,
I'm having a strange problem with updating records in my Airtable. I set up an automation where it checks if a record with a specific user ID exists. If it does, it updates the record, and if not, it creates a new one.
I deleted all the records from the table. Now, even though the table is empty, the update is failing because the automation is finding two record IDs that don't exist anymore.
Empty Table:
Run automation :
The update will fail as it refers to the previously deleted records' IDs. Is it a cache issue of some sort?
Any ideas on how to fix this?
Thanks!