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 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...
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 Google Apps PropertyService to store some settings variables. When I use the setProperties() function and give it an object (just like they do in the documentation) and then try to get a property and parse it I am getting a SyntaxError: Un...
I am trying to collect response details from a google form using a script bound to the form, using the onFormSubmit() trigger.  Most times the details are received without error, but once in a while I get an error. The trigger is received but no data...
I have a Google form that collects reddit usernames in a Google sheet. I have a script to check whether the username doesn't exist (i.e. https://www.reddit.com/user/<username> gives a 404) or is banned (username looked up against a list var...
I'm having trouble with Google Forms/Sheets - and just so you know from the start I'm not much of a coder, and I'm VERY new to working with Apps Script.  I'm trying to make the following happen:  1) Have a user answer a single questio...
I want to do a survey in which a participant listens to a sound (I link to a Google Drive .mp3 file in the question), then they respond by using an embedded colour picker to drag and choose a specific hex code.  The widget would be similar (if not th...
I would welcome any help with getting a script to work on Form onSubmit to then take the last line (New Form submitted information) from the sheet 'New Orders' to then copy the required columns into the 'DIBOND ORDERS' sheet so it wil...

Tags

Recent Questions

Top Questions

Home Tags Terms of Service Privacy Policy DMCA Contact Us

©2020 All rights reserved.