4 votes

How to select multiple, non-consecutive cells in Google Sheets using a list of the cell addresses

To select cells with a script: var sheet = SpreadsheetApp.getActiveSheet(); var rangeList = sheet.getRangeList(['C3', 'C7', 'C17', 'C56']); sheet.setActiveRangeList(rangeList); The last range in ...
H.He's user avatar
  • 41
3 votes
Accepted

Add my scripts or add-ons to new Google doc

There are two basic categories of Apps Script files - Bound to the document (Sheet, Doc, Form) Stand Alone Bound files do not show up in your Google Drive. Stand Alone Apps Scripts files do show ...
Alan Wells's user avatar
2 votes

How to test apps script addon

The problem is that the onOpen function is incomplete; .addToUi(); is missing. This is the onOpen function on the referred guide /** * Creates a menu entry in the Google Docs UI when the document is ...
Rubén - Volunteer Moderator -'s user avatar
2 votes
Accepted

How to select multiple, non-consecutive cells in Google Sheets using a list of the cell addresses

Update On April 2018, several new classes and methods were added to the Google Apps Script Spreadsheet Service including Class RangeList and methods to get this class were added to Class Spreadsheet ...
Rubén - Volunteer Moderator -'s user avatar
1 vote

How to test apps script addon

Solved It Found guidance from this article In order to test Switch back to the legacy editor Select Run > Test as add-on Configure Test Select version: Test with latest code Installation Config: ...
Sameer Khan's user avatar
1 vote
Accepted

Linking an Add-On to a Drawing

I'm not sure that this is possible but if it was possible, to assign a function to a drawing you should know the name of the function and that function name should not be used on any other add-on or ...
Rubén - Volunteer Moderator -'s user avatar
1 vote

What Add ons are available to give Google Sheets features similar to Excel Tables and Structured References?

This doesn't seem to be an area that has receive much attention for add ons. Partial workarounds: Create a naming convention using an abbreviation of the tab as the start of the named ranges. This ...
Sherwood Botsford's user avatar
1 vote

What Add ons are available to give Google Sheets features similar to Excel Tables and Structured References?

Use Data->Named Ranges to manually accomplish the same thing (you will need to specify an entire column however as it will not auto-expand downward (without GAS). It is strange indeed that Google ...
CodeCamper's user avatar
1 vote

Using Google Sheets cell reference in SOQL Query

Figured out a workaround at least for my use case. There doesn't seem to be a way to use local references in these queries that I can figure out, but you can import your full set of data into separate ...
user229790's user avatar
1 vote

My Add-On was approved by Google, but it is available only to members of my employer's domain

Publish a Google Add-on to the G Suite Marketplace Basic Concepts: You must use the G Suite Marketplace SDK in order to get to the “Publish” section for publishing an add-on, and you must first open ...
Alan Wells's user avatar
1 vote
Accepted

Creating Google Forms from Google Spreadsheet

The FormCreator app was created using Google Apps Script. For more specific details see Develop Add-ons for Google Docs, Sheets and Forms
Rubén - Volunteer Moderator -'s user avatar
1 vote

How to automatically create a templated Google sheet?

Try this: This function get called when 'Create Sheet'!B1 gets edited with a new name. function onEdit(e) { var rg=e.range; var sh=rg.getSheet(); if(sh.getName()=="Create Sheet" && rg....
Cooper's user avatar
  • 134
1 vote
Accepted

Where can I find the number of add-ons for each category in the Google Sheets Add-ons store?

I think a hack is possible for one category at a time. Select the category, scroll down to the last entry (no See More), Ctrl+A, Ctrl +C, then in the top row of a spreadsheet Ctrl+ V, scroll down to ...
pnuts's user avatar
  • 17.6k
1 vote

Copy data to a new spreadsheet with specific name

I wasn't logged in when I asked this question, but here is the script I am using to achieve this if anyone wants to use it. function CopySheet() { var ss = SpreadsheetApp.getActiveSpreadsheet(); var ...
mcktj's user avatar
  • 23

Only top scored, non community-wiki answers of a minimum length are eligible