EMAIL NOTIFICATION BASED ON RESPONSE

[CRISTIANO RONALDO. CR7]

MY RESPECTED PEERS;

I am new to a google form. I have developed a simple google form and need your assistance in that. I have checkbox question and wanted that the email notification will be sent to the respective user based on the checkbox.

it will be like this

a. if check box A selected (Email sent to kulis...@gmail.com)

b. if check box B selected (Email sent to julie...@gmail.com)

please help me how can I do this in the google form. please this my humble request for urgent assistance.

[Andres]

Hello,

I believe you can do this with a formula in the Google sheet where the Form submissions are stored:

Have one column with the formula that checks as follows...

If the contents of the answer are "Checkbox 1", use email 1(kulis)

If the contents of the answer are "Checkbox 2", use email 2(julie)

I created a Google sheet to show the example formula, it is a simple IF statement but can be more complex if your responses can have more than one answer (such as multiple check boxes are checked).
https://docs.google.com/spreadsheets/d/1flR-SNZtLAKJx4A1rdJS2BjX73xhmaUpgKEBsBDlHPc/edit?usp=sharing

Once you have done the formula as you need, you will have to set the settings in Formemailer to use closure mode: formulas, and enter the "Sheetname!A:B" in the formula location field of the settings, in my example the script isn't installed so I don't have the settings as an example.

Hope this helps.