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 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 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...
I have a script for creating multiple Google forms. within each Google form, I want to create an onFormSubmit trigger to post the responses to a selected spreadsheet.   Using installable triggers but the trigger doesn't seem to get embedded into...
I am trying to add validation, specifically text validation, for my google form text items.   However, it looks to me like the 'setValidation()' function only works with items with known type like TextItem.  To my understanding, if I pull a f...
I have a google form that links to a google sheet. On form submit, the responses automatically fill out a doc template and generate a pdf, saving it on drive. I also have a script that populates a column with the edit link for the form submission if...
This question already has answers here:...
I wrote a google spreadsheet script that parses a spreadsheet and creates a form with the data.   Once the form is created, I can manually go to the form settings -> Quizzes and then "make this a quiz". Once I make it a quiz, I can manuall...
I'm very new to Google Forms and Spread Sheets and what I wanna do is that I have an "Age" question in my form, and when the user submits the form I want it so that if the age is below 18, a cell gets the value "MINOR" and if it i...
I am using the enhanced workflow script that was posted by Mogsdad here.  I have managed to work out a few issues but one that I am stuck on at the moment is the error that comes up from this section -  // Record approval or rejection in spreadsheet...

Tags

Recent Questions

Top Questions

Home Tags Terms of Service Privacy Policy DMCA Contact Us

©2020 All rights reserved.