Google form addons for conditional notifications

#Google form addons for conditional notifications how to#
#Google form addons for conditional notifications code#
#Google form addons for conditional notifications plus#

To add more questions to your form, click the plus sign (+). Doing this makes it a lot easier to differentiate each section and link answers together. You can create a new section by clicking on the icon that looks like two rectangles. Once you have the survey open, separate the questions that will have branching logic into different sections. RELATED: The Beginner's Guide to Google Forms If you donвЂ™t already have a survey prepared-or if you havenвЂ™t ever used Forms before-check out our beginnerвЂ™s guide to Google Forms to help you get started. The first thing you want to do is open the Google FormsВ survey where you want to use logic branching. HereвЂ™s how you can use branching logic to send people to questions that pertain to their responses.

#Google form addons for conditional notifications code#

Paste the following function into the code window.When you create a survey with Google Forms, you can use conditional questioning to send respondents to specific pages based on their answers. If youвЂ™re using the same spreadsheet, youвЂ™ll still have the SendEmail() function in there. Go back into your Script Editor window by clicking on Tools and then Script Editor. LetвЂ™s create the Google Apps Script that does that. Imagine that you want to know every month whether your total sales have dropped below $16,000. Keep in mind that cell D2 is the one youвЂ™re going to want to check and compare.

#Google form addons for conditional notifications how to#

The next step youвЂ™ll learn is how to read a data value out of a Google Spreadsheet, check the value, and issue a pop-up message if that value is above or below an upper limit.Д«efore you can do this, youвЂ™ll need to create another sheet in the Google Spreadsheet youвЂ™re working with. Now that youвЂ™ve successfully written a Google Apps Script that can send an alert email, itвЂ™s time to make that alert email more functional. Step 2: Reading a Value From a Cell in Google Sheets Your script will run, and the email address you specified in your spreadsheet will receive an email like the one below. Just click on Advanced, and then click the Go to SendEmail (unsafe) link. This alert screen is because youвЂ™re writing a custom Google Script that isnвЂ™t registered as an official one. So the first time you run the script, you may see an alert like below.Д¬lick on Review Permissions, and youвЂ™ll see another alert screen that youвЂ™ll need to bypass. Keep in mind that Google Script needs permission to access your Gmail account to send the email. Save the script by clicking the disk icon, and then run it by clicking the run icon (right arrow). The ndEmail function finally performs Google Scripts send email feature using your connected Google account.

var message and var subject define the text thatвЂ™s going to build your alert email.getRange and getValues pull the value from the cell specified in the getRange method.Var subject = 'Your Google Spreadsheet Alert' Var message = 'This is your Alert email!' // Second column Var emailAddress = emailRange.getValues()

Var emailRange = SpreadsheetApp.getActiveSpreadsheet().getSheetByName('Sheet1').getRange('B2') Next, paste the following code inside the SendEmail() function: // Fetch the email address YouвЂ™ll see a script window with a default function called myFunction(). To get into the script editor, click on Tools, and then click Script editor. Now that you have an email address to send an alert email to, itвЂ™s time to create your script. Just add a name column and an email column, and fill them out with the person you want to receive the alert email. YouвЂ™ll also need to create a new spreadsheet that contains an email address. Step 1: Sending an Email with Google SheetsД«efore you can create a Google Apps Script to send an email from Google Sheets, youвЂ™ll also need a Gmail email address, which Google Apps Script will access to send out your alert emails. ItвЂ™ll also save you the time of having to monitor your spreadsheet updates manually. No matter the application, this script is compelling. Or you could get an email if your employees report that theyвЂ™ve billed the client for too many hours in your project tracking spreadsheet. You could receive an alert if the daily earnings in your sales report dip below a certain level. IfВ the value is over a certain threshold limit, you can automatically send an alert email to any email address you like. In the following tutorial, you will learn how to check the value of a cell in Google Sheets.