I have a squarespace website which currently interacts with zapier and airtable to create a new record in my airtable base every time I submit a form on my website. That same form submission also causes an acknowledgement email, containing form data, to be sent to an email address inputted by the website user into the form. In general I am trying to find a database solution which will work with my squarespace website, and airtable is one of the candidates. I need my squarespace website java script code (which I am well versed in) to be able to do the following: 1. Search the airtable base for a record; 2. perform an atomic read/update function on the record so that only one website instance at a time can read/update and no other website instance can access the record in between the read and update. I need to find out if this is possible by integrating squarespace and airtable, and if so I need to be pointed in the right direction concerning implementation. I am not certain, but if there is a solution I suspect the java script on my squarespace site would somehow have to gain access the airtable API for my airtable base. Thanks pjm.
