Google Apps Script (GAS) is a JavaScript cloud scripting language that lets you extend Google Apps and build web applications.
2
votes
2answers
136 views
Viewing all group contacts information in one page
Say I have 5 contacts in a group. I would like to see all their details in one page (/view), preferably separated by an horizontal line between every contact.
Is something like this possible?
0
votes
2answers
188 views
Selecting Values from separate sheets and aggregating the results with google spreadsheet
I would like to use the query function to select values from two separate sheets add them together and do a less then comparison to another value. I have used named ranges for the data that I am ...
0
votes
2answers
821 views
Create a dropdown list of options from VLOOKUP
What I'd like to do is get a dropdown list of options from a VLOOKUP type function where I can select the value for the next lookup.
Example
Here the data I'm using for reference. Notice "AAA" ...
3
votes
1answer
586 views
Auto create and name new sheet in Google Spreadsheet
How can I automatically create and name new sheets in a google spreadsheet from a list of names, such as a student roll sheet? I would like each new sheet to be created when I add corresponding names ...
1
vote
1answer
98 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 ...
0
votes
1answer
48 views
Google spreadsheet multiple auto-sorting
In a Google Spreadsheet I have different group of cells to auto-sort ascending i.e.
table range a3:c16 columntosortby = 2
table range d18:f31
columntosortby = 5
table range g33:i46 columntosortby = ...
0
votes
1answer
37 views
Repeat range under each other in Google Spreadsheets
I have a range of two columns with year and dates. In another sheet I want to repeat this range for X amount of times under each other. How can I do this?
So for example I have this range:
Year | ...
3
votes
0answers
131 views
GmailApp service for consumer Gmail accounts?
I successfully set up Gmail Snooze in my google apps accounts (for work) and I like it so much that I want to set it up for my personal email, too (@gmail.com).
I followed all the same instructions, ...
2
votes
0answers
444 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 ...
2
votes
0answers
191 views
Cumulative Sum without Script
For this question, I've created a Google Apps Script function, that calculates the cumulative sum of a range. Martin Hawksey on Google+ made a comment about a more efficient way of calculating the ...
1
vote
0answers
53 views
Set a Category Filter in a Google Spreadsheet Line Graph
I've got a google spreadsheet that tracks status updates to a series of projects over time. The table rows each list a particular month (01/2012) and the columns list the status change ("Ready for ...
1
vote
0answers
38 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 ...
1
vote
0answers
80 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
84 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
0answers
56 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
32 views
Google Apps Script UrlFetchApp and password protected pages
I'd like to be able to use Google Spreadsheets to login to my registart and automatically list into rows the current name server and email settings of all my sites, rather than use the heinously ...
0
votes
0answers
45 views
Google Docs - If cell equals a value then move row to different Google Spreadsheet
I've got a script that sorts a Google Spreadsheet when a value in a column is changed.
I'd like to add to the script the following functionality:
If the value for column E = "Complete" then the ...
0
votes
0answers
95 views
How to use Google Scripts w/ spreadsheet and jotform to auto sort so the newest entry is always listed on the top row?
I'm trying to setup a form and spreadsheet database to track inventory on a daily basis at a remote location. The idea is that the person at the remote location can update our stock via a simple ...
0
votes
0answers
47 views
Download list of contact information and check if Google Account
I'm looking for a way I could:
retrieve a list of all my contacts and their email's and
In order to retrieve a list of all of my contacts into a Google spreadsheet, I exported them as a Google CSV ...
0
votes
0answers
122 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 ...
