I’m having trouble with what should be a very simple zap and hoping someone can point me in the right direction or help me report a bug if that’s needed.
Context:
- I am using Tally to collect user information and add it to an airtable base
- One of the questions is optional and if they skip it i send them a follow up tally form to re-submit it later. That tally form has their user id automatically filled out so I can match it to the original record
- The zap I’m trying to build is designed to trigger when the user fills out the follow up form. It will then find their record in airtable and update the field they left blank with their response (in this case an attachment)
I am getting an error on the search airtable step where it’s not finding the record. Here’s the details
- I have a test record from my tally form selected where the user id is PZXkbQ
- Note - this record does have a different respondent id which means the user filled out this form on a different browser/device than the original form BUT the original ID (PZXkbQ) is hardcoded into their form submission via the user id field (and they can’t change it because it’s hidden)
- I’ve checked that the base, table, search by field, and search value are all correct in zapier
- I’ve tried both `User ID` and `user-id` fields as well as hard coding the ID
- I’ve also tried “exact match” and “contains” for search type
- I’ve checked that the record I want to update is in the airtable base
- Despite all of this, I keep getting an error that it’s unable to find the record. I’ve tried refreshing, redoing the zap from scratch, refreshing the airtable fields etc and none of it has worked
Is there a known bug or am I missing something? Any ideas would be welcomed!
