Hello! I'm new to AppSheet but love it so far...

(Tom Becknell) #1

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.

(Tom Becknell) #2

Hi Suvrutt, Thank you very much for this information.

I’ll run with.

Much appreciated! -Tom

(Suvrutt Gurjar) #3

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.