Here at the City of Reno, we're considering purchasing a company Zapier plan, but before we do we'd like to make sure it would work how we want it to. I'm trying to create a Zap that will edit a Google sheet once a specific answer to a question is submitted in a Submittable form. The purpose of this functionality would be to notify a department once a submission comes in that involves them specifically, based on the answer to a question.
As far as I can tell, there are no trigger options available yet that are dependent on specific questions. Perhaps if this feature were added or I could find it, senior management could be convinced to spend money on the zapier subscription.
Please let me know if this is something that can be done, or where my best path for assistance is!
Have a great rest of your day everyone,
