I have two google forms, which send data to two tabs in a single spreadsheet.  I have set up a script with two functions.  I would like the first function to run on submission of the first form.  And, the second function to run on submission of the s...
I have been reading and watching many tutorials online but I could not find something that I can initially load some kind of dialog box or login page with a single input text so then I can process that using apps script.  onFormOpen() is not triggere...
I want to embed a Google form in an email and send it with MailApp. I'm attempting to use code found at: https://stackoverflow.com/a/23671529/4305236:  var form = FormApp.create('New Form'); .... var url = form.getPublishedUrl(); var resp...
I created a simple Google form with the fields:   Name, E-mail, Salary and Request.  When the user completes the form, I want to send him/her an e-mail with the info.  However, I want to use the "Request" field to plug in a unique number that...
I have created a google form with an email field. Responses are stored in a spreadsheet. On submit I take the last row from the sheet (latest response) and send an email to that user.   I have tried to implement a lock system, however it does not wor...
NOTE: This issue has been brought to the attention of google dev's and they are apparently looking into solving this. There is no solution yet, please see here if this issue affects you too!    I have been working with a small project for a whi...
I am writing a program that requires the ID of various google form responses. My program first creates the form object and gets the responses:  var form = FormApp.openByUrl("..."); var allResponses = form.getResponses();   If the form respons...
I am having an issue with the following code when trying to iterate through the items in a form and delete them to make way for new sections/questions.  However, I sometimes get the following error "Invalid data updating form".  I have worked...
I'm having major headaches trying to work with dates and times and it's consuming hours of my programming time, so any help much appreciated.  What I'm trying to do is combine a separate date and time; It's easy enough to separate out...
I have this function which works but it gets all responses.   function setEditUrl(ss, createDateColumn) {   var formURL = 'https://docs.google.com/forms/d/101bMiRw9TQaGbdDc4U_tLAD0QzicqejM9qXOEwJPQKU/viewform';   var urlColumn = createDateCol...

Tags

Recent Questions

Top Questions

Home Tags Terms of Service Privacy Policy DMCA Contact Us

©2020 All rights reserved.