I am trying to do something that should be very simple. I have an AirTable with 172 records with names, email addresses, etc. I would like to populate those records with the results of a JotForm survey I plan to email out to those 172 people. I have created a “Zap” that goes 1. Jotform: New Submission → 2. AirTable: Find Record → 3. AirTable: Update Record.
All stages are testing correctly. I search on the field “email” in step 2 and use the ID it returns in step 3 to uniquely identify the record. I select a field from the JotForm (say, “emergency contact”) that I would like to be added to the appropriate field in the existing entry for that email address.
Whatever I do, it creates a new mostly-empty record with”email” and “emergency contact” populated and does not add the emergency contact to the existing record. This should be impossible; I do not have “Create record” selected anywhere, only “Update record". Clearly I am overlooking something but I have no idea what.
