All Questions

34
votes
2answers
12603 views

How can I test a trigger function in GAS?

Google-apps-script supports Triggers that pass Events to trigger functions. Unfortunately, the development environment will let you test functions with no parameter passing, so you cannot simulate an ...
53
votes
1answers
85547 views

Is it possible to 'prefill' a google form using data from a google spreadsheet?

I'm looking for a way to 'pre fill' a google form with specific data from a google spreadsheet. The form will have the same 'standard' questions for everyone, but the data in the first two question wi...
20
votes
2answers
38736 views

Create Google Calendar Events from Spreadsheet but prevent duplicates

I'm trying to write a script that will take data from a Google spreadsheet and create events in my Google calendar. I managed that fine but it produced duplicates every time I ran it. So now I'm try...
12
votes
1answers
3429 views

How to poll a Google Doc from an add-on

A documented restriction with document and sheet add-ons is that Apps Script cannot tell what a user does outside of the add-on. This tantalizing tip is given: It is possible to poll for changes i...
26
votes
3answers
71807 views

How to automatically import data from uploaded CSV or XLS file into Google Sheets

I have a legacy database system (not web accessible) on a server which generates CSV or XLS reports to a Google Drive folder. Currently, I am manually opening those files in Drive web interface and c...
17
votes
3answers
12341 views

How to protect the Apps Script code in a Google spreadsheet?

I have written some code for my Google spreadsheet with the script editor. I want to share this spreadsheet with my clients but I don't want to share the code I have written. This code adds a menu t...
55
votes
6answers
42748 views

Refresh data retrieved by a custom function in google spreadsheet

I've written a custom google-apps-script that will receive an id and fetch information from a web service (a price). I use this script in a spreadsheet, and it works just fine. My problem is that the...
6
votes
5answers
14733 views

Detect user inserting row or column in a google spreadsheet and reacting in a script

In Google Apps Script, one of the basic tools is the onEdit trigger in a spreadsheet, which enables us to detect when a user edits a cell, and react to it. How about when a user inserts a row or colu...
89
votes
6answers
80993 views

Accessing Google Spreadsheets with C# using Google Data API

I'm having some information in Google Spreadsheets as a single sheet. Is there any way by which I can read this information from .NET by providing the google credentials and spreadsheet address. Is it...
10
votes
6answers
15386 views

Script to summarise data not updating

I have a Google spreadsheet of timesheet data; it has a sheet for each month, each sheet is a lot of six column blocks, one block per client. I have created a summary sheet that goes and gets the tot...

Previous Next