Hello! I’m new to AppSheet but love it so far. I created a very basic app that has is a short survey form with Yes/No questions. The help I could use is if anyone who fills it out selects a “No” on any of the questions in the survey, for it to send out an email, text, etc.
It could be a “No” on one of the questions or several.
I only want to receive the email, text notification when that occurs.
Can anyone advise how that’s done? I was playing around with the workflow but couldn’t seem to get it right. Any help would be much appreciated.
Hi Suvrutt, Thank you very much for this information.
I’ll run with.
Much appreciated! -Tom
Hi @Tom_Becknell,
Presume you wish to receive the email after the survey is submitted. If this is so, please explore following approach.
If you have say 4 questions in the survey, you could create a VC called say AllAnswers by concatenating Y/N responses columns to all answers. CONCATENATE( [Answer1],[Answer2],{Answer3],[Answer4])
In workflow rule (Under…IF THIS IS TRUE…), please have a condition expression
such as
CONTAINS([AllAnswers], “N”)
Please create the workflow rule for update event “ADDS ONLY”
You will receive an email if any ( or more or all) of the answers is /are “No” after the user submits the survey.
User | Count |
---|---|
44 | |
29 | |
22 | |
20 | |
14 |