| User confirmation Email after submitting Google Form - Script | TheDarkMist | 3/15/10 4:37 AM | Does some programmer made some public script and/or tutorial to make possible to send an email to a form user? Probably with the new scripts feature it is possible? |
| Re: User confirmation Email after submitting Google Form - Script | ahab | 3/15/10 4:57 AM | The problem with handling this automatically from a script is that there is no trigger function that would allow an unattended reaction as a result of the submit - there is no onSubmit trigger (like the onOpen and onEdit triggers that are available). |
| Re: User confirmation Email after submitting Google Form - Script | TheDarkMist | 3/15/10 5:35 AM | I'm not a programmer, so I cannot do such things :( |
| Re: User confirmation Email after submitting Google Form - Script | michealhunt | 3/24/10 6:56 AM | you can save state, by creating another column that is not being used by the form, however; you are still blocked by the fact that there is no onSubmit trigger. The on edit event is not fired by a new form entry, so there is no way to do this in scr |
| Re: User confirmation Email after submitting Google Form - Script | dieginjo | 4/11/10 9:54 PM | Use this as a template: function sendEmails() { var sheet = SpreadsheetApp.getActiveSheet(); var startRow = 2; // First row of data to process var numRows = 2; // Number of rows to process // Fetch the range of cells A2:B3 var dataRange = http://sheet.ge |
| Re: User confirmation Email after submitting Google Form - Script | dieginjo | 4/11/10 10:04 PM | Scratch that:Follow this link for the comprehensive tutorial. |
| Re: User confirmation Email after submitting Google Form - Script | michealhunt | 5/20/10 6:16 AM | see: http://www.google.com/google-d-s/scripts/events_overview.html it is now possible to have your script fire up to every minute to check for changes (i.e. new form entries). While this still isn't quite the same as an onSubmit trigger, it will al |
| Re: User confirmation Email after submitting Google Form - Script | RGuz | 6/27/10 12:55 AM | I've been working on a signup form and I wanted to send a confirmation email when a user submits the form. Google has added a working "On form submit" trigger, so I decided to tackle the other half of the problem, tracking which submissions have alre |
| Re: User confirmation Email after submitting Google Form - Script | ahab | 6/27/10 7:34 AM | Some users may want't to start with a slightly more simple script that directly works with the data actually submitted . See [1]. |