I am working on setting up what should be a simple zap, but I’m running into a really frustrating issue. What I need to do is send data from a Google Sheet and have that data populate a form in Zengine. The zap should look like this:
- Trigger: New or updated record in Google Sheet
- Find Record in Zengine (using a data field from the Google Sheet)
- Update Record in Zengine
Where I’m running into issues is with step 2. I need to locate the record based upon a project ID, which is a number field. When I try to enter that, I only get 2 options for number fields:
The problem with this is that I need a search condition that will allow me to search for a number that matches exactly. Using < or > is never going to work for this. But I cannot for the life of me figure out how to force Zapier to search for the exact record or find a workaround. Thoughts?
