Hi everyone, I’m building a Morse Code website that converts text into Morse code and stores user submissions in Airtable through the Airtable API. The website is connected using JavaScript fetch requests and a Personal Access Token. The issue I’m facing is that records are sometimes created successfully, but updates to existing records either fail silently or create duplicate entries instead of updating the original row.
My current workflow is: first I send a GET request using filterByFormula to check whether a record already exists, then I either PATCH the existing record or POST a new one. Even when the API response returns status 200, the Airtable base occasionally does not reflect the expected changes. I suspect the issue could be related to incorrect filterByFormula syntax, record ID handling, async timing in JavaScript, or Airtable caching/rate limits.
Has anyone experienced similar problems with Airtable API integrations? What is the most reliable method to prevent duplicate records and ensure updates happen correctly? If possible, I’d appreciate recommendations for best practices, debugging strategies, or example implementations for searching and updating records safely in Airtable.