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 |
---|---|
40 | |
35 | |
30 | |
23 | |
17 |