Google Apps Script (GAS) is a JavaScript cloud scripting language that lets you extend Google Apps and build web applications.
1
vote
0answers
48 views
How to share Company's directory with all users using Google Apps shared Directory?
I am using the code given in the answer to this question:
Is it possible to pull my Company directory into Google sites intranet?
However, as it specifies, it works for admin only. Would it be ...
1
vote
0answers
28 views
Looping through the range of cells to test the dates
I am trying to create a function to check the dates in 'Dt' sheet and return Match or Not Match.
It works fine with when I display my answer in MsgBox, but when I try to do it in one of the ...
3
votes
1answer
34 views
How to report which checkboxes were left unchecked on a Google Forms submission?
I have a Google form that stores its responses in a Google spreadsheet. It's set up so that whenever someone submits the form, I receive an email report of the responses. There are many places in the ...
1
vote
1answer
44 views
Iterated variable (i) for argument on range in Google Scripts API
for (i=0; i<numItems; i++) {
var cell = sheet.getRange(12,i);
cell.setFormula(i);
}
This simple formula should go to every place on the column 12 where there is data, and replace it ...
2
votes
1answer
46 views
Google Spreadsheet Sort Two Columns
So I've found the following answer in regards to auto-sorting by one column, which works great
How can I make some data on a Google Spreadsheet auto-sorting?
However, my use case requires the sorting ...
0
votes
1answer
58 views
How do I Sum Thoughout Different Sheets
How do I create a reference to a defined interval in several sheets?
Something like this: =SUM(Sheet1:Sheet2!A1)
1
vote
0answers
61 views
Create new document within spreadsheet and link
I would like to create a spreadsheet script that allows me to create a new document every time I click on a new cell or row and then have that document links back to that cell.
1
vote
0answers
57 views
Shared Google spreadsheet: enabling app script to run as author
I created a spreadsheet that I'd like to share with anyone with the url.
The sheet contains several app script functions. These functions both change the content of the sheet and copy data to another ...
1
vote
1answer
123 views
How do I automatically update a cell in Google Spreadsheets to the most recently entered in the same row?
I am trying to have one column that will show the most recent thing i entered in the row. Example: I want B2 to be the same as D2 but once I enter something in E2 I want B2 to display that. And then ...
1
vote
1answer
90 views
Why Gmail Meter is not working
I added Gmail Meter to my Gmail account but it never reported anything. Do you know what could be the matter? I worked to authorize and add the script, then I waited and nothing happened. When I go ...
1
vote
0answers
40 views
Google Spreadsheet: the script enabling email sending to a cc list doesn't always work
We have a Google Forms that, when filled, is sending out a list of people put on cc. This doesn't always work.
How can this issue be solved?
0
votes
0answers
106 views
How do I get an onEdit script to run on a Google Spreadsheet for all users
I created an onEdit script which re-sorts a Google Spreadsheet every time a cell is edited.
The Google Spreadsheet is shared amongst multiple users and I'd like the script to run for all users, every ...
0
votes
0answers
20 views
autosort script troubles [duplicate]
autosort script from @wolf was working fine but no longer...
any thoughts?
function onEdit(event){
var sheet = event.source.getActiveSheet();
var editedCell = sheet.getActiveCell();
var ...
2
votes
0answers
329 views
Google Spreadsheets: add unique QR code field to a spreadsheet based on a form in google docs using Script Trigger
At the end of each row filled in, using a custom Google Form, I'm adding three more columns:
Date of creation
Unique ID
QR code (it is a list of computers)
Unique ID and QR code are unique. QR ...
0
votes
0answers
96 views
How to read a multiple values in cell in each row (separated by comma) in a Google Spreadsheet
I have problem in reading cell with multiple values and comparing the each value with column from a-z if match found then set value of the cell has '1'.
Problem: I need to take multiple company names ...
