Tag: google-forms

Create an Identification Question WITH Answer, in Google Forms Using Google Script

google-apps-script google-forms javascript python

I’ve been trying so hard to understand javascript as I know only Python. I generate javascript codes using Python, to run it on Google Scripts. I was able to automate creation of any number of Multiple Choice Items by generating codes to be used as script, but I could not figure out how to make a script for Identification Questions

Modify Google Forms confirmation page to display the time stamp using App Script .gs

google-apps-script google-forms javascript

I watched this youtube [1] which is in Hindi. I don’t understand what he says but see what he does and that it works. So I tried to replicate to get the same result: for the Confirmation Page of a Google Form to display the date and time. I actually prefer to get the submission time stamp, but perhaps it

How to change title of an event?

google-apps-script google-calendar-api google-forms javascript

I am trying to update the title of the events in the last 7 days in a specific calendar, when an user submits a form. I have this code now: However, I get that error when running the code: TypeError: events.setTitle is not a function myFunction @ update.gs:22 I tried many different ways of doing it, but it always ends

Google Apps Script successfully triggers On Form Submit, but function will not execute

google-apps-script google-forms google-sheets javascript

I’m trying to copy a row from the linked form responses sheet “main” to another sheet “sub” if a value in the form response matches a particular criteria, Column 4 = “Subset” I have onFormSubmit set up as a trigger with Deployment – Head, Source – Spreadsheet, Event – On form submit. When I submit the form, the trigger for

Issue in creating script that copy the sheet and update it based on form response

google-apps-script google-forms google-sheets javascript

I am trying to make a copy of Template in same folder when user submits the form and than update the fields in new copied sheet based on what user has submitted in the form response. New sheet is creating successfully but response I am getting in the form is not updating in the new sheet. Need help in finding

Google Form on Submit get values and format the time

google-apps-script google-forms javascript timezone

I am using Google Apps Script with a Google form. When the user submits the Google Form I get a value from a question. I then take that value and make it a date object, from what I saw on this post about daylight savings I use that to determine the timezone. I run the date object through Utilities.formatDate and