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-apps-script

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

How to skip to next row of iteration without ending the function if a certain cell is NOT BLANK in google apps script

I need my code to check cells within two different columns and skip to the next row if certain conditions (listed below) are met. I am not sure why I can't figure this out. I'm sure it's simple, but m...
test-img

Kenneth Cook

javascript

loops

for-loop

google-apps-script

Votes: 0

Answers: 0

Apps Script: Batch Create Calendar Events without Creating Duplicates

I'm working on a script that takes a list of tasks from Google Sheets and automatically creates events on Google Calendars, putting the event on the Calendar of the team member to whom the task is app...
test-img

dylan-bush

javascript

google-apps-script

google-sheets

google-calendar-api

Votes: 0

Answers: 1

Latest Answer

In your situation, how about the following modification? Modified script 1: In this sample script, the value of X is put in the "Scheduled" column. function scheduleTasks() { var spreadshe...
test-img

Tanaike

Apps Script Add-on Card Service Refresh Issue

I created add-ons with the card service. All I wanted is to run the function refresh() to clear data in Spreadsheet and add-on should refresh once I press Logout Button. I use the below code to try ru...
test-img

Moses01

google-apps-script

web-applications

google-workspace-add-ons

Votes: 0

Answers: 0

Posts

Questions

Blogs

Jobs