python (65.1k questions)

javascript (44.2k questions)

reactjs (22.7k questions)

java (20.8k questions)

c# (17.4k questions)

html (16.3k questions)

r (13.7k questions)

android (12.9k questions)

Questions - google-forms

Retrieve answers from a checkbox grid of a Google Form with Google Apps Script

I'm trying to store the data of a Google Form into a Google Sheet. In the Google Form there's a checkbox grid that contains a list of questions. I want to get the values (the answers) of the checkbox ...
test-img

Angélica Castillo

google-apps-script

google-sheets

google-forms

Votes: 0

Answers: 1

Latest Answer

Instead of including yourVariable  as an element of array use JSON.stringify(yourVariable). From https://developers.google.com/apps-script/reference/forms/checkbox-grid-item For CheckboxGridItem que...
test-img

Rubén - People First

Google Form Api. Adding Response validation to textQuestion

Currently, AFAIK, when performing google form batchUpdate using the google forms API v1, we are only able to set the shuffle property of choiceQuestions, while for textQuestions there are no options t...
test-img

Marlon Dumal-is

google-api

google-forms

google-forms-api

Votes: 0

Answers: 1

Latest Answer

You are correct, this has not been implemented yet. For now, these are the only options that can be used with ChoiceQuestion This is kind of expected taking into consideration FORMS API was launched j...
test-img

Yancy Godoy

Specific form id submission - email trigger from spreadsheet data

Looking for a way to trigger email script when specific form eg.form1 is submitted. I have 2 forms form1 & form2, responses of both the forms are captured in 2 different sheets of same workbook. I...
test-img

Vasuki Rao

google-apps-script

google-sheets-api

google-forms

eventtrigger

Votes: 0

Answers: 2

Latest Answer

Have you tried getting the sheet name that has been updated by the event? that way you could use that info to filter the responses. function myFunction(e) { var updatedRow = e.range; var sheet = upd...
test-img

Matias CG

Google Sheets/Form Not Updating Properly

I have a Google form that I am using to collect a rather large amount of data. The form responses are going to a Google sheet. From that Google sheet I am running several queries and using importrange...
test-img

Joshua

google-sheets

google-forms

Votes: 0

Answers: 1

Latest Answer

try forcing it: =IF(NOW()=NOW(); QUERY(...); ) and check the settings:
test-img

player0

Posts

Questions

Blogs

Jobs