New answers tagged

0

At this time this it's there are only two kinds of range properties to handle its content: values and formulas. Unfortunately changing the cell content using them removes the format applied to parts of the content. In case like this, users could take a look to the Google Apps Script Issue Tracker to search for a feature request and in case that there isn't ...


-1

Why don't you simply copy this list, with each choice on a separate line (in a text file) or in cells along a column and then paste (ctrl+v) in option 1 textbox? Doing this will generate the pasted items as separate choices, simple!


0

This is how such a script can work. The variable startRow is fixed at 12 here - an alternative option is to take it from the current selection, which would be startRow = sheet.getActiveRange().getRow(); The script then searches column A for "end of list" text, and then deletes the required number rows. function deleteRows() { var startRow = 12; var ...


2

The message is pretty clear: you are invoking the service too often. This is discussed in Google URL Shortener 403 Rate Limit Exceeded which indicates that the acceptable rate is somewhere between 1 and 10 requests per second. Use the method Utilities.sleep to slow down the requests. For example, Utilities.sleep(1000) within the loop will ensure a 1-second ...


1

onEdit can be written to take an event parameter that among other things contains the range that was edited. Changing the function declaration to take a parameter 'event' and changing r to be event.range instead of the activecell gets the exact behavior I believe you want. function onEdit(event) { var s = SpreadsheetApp.getActiveSheet(); if( ...


1

The Google Apps Script Editor doesn't include print command and doesn't have a command to wrap lines either, so we could say that it's not print friendly. One solution is to to copy the code and paste it to another app that include better print options. Another alternative is to use a desktop editor. See External Editor Support for Google Apps Script - ...


2

The function ImportJSONBasicAuthentication is basically just a wrapper function for ImportJSONAdvanced but changes some options before calling it (the line with var fetchOptions initiliaztion call sets up options accordingly). You'd need to include the function ImportJSONAdvanced and any functions it might also call (dependancies). Notice the return value ...


1

This can be done. One can get a reference to the passed range by parsing the formula in the active cell, which is the cell containing the formula. This makes the assumption that the custom function is used on its own, and not as a part of a more complex expression: e.g., =myfunction(A1:C3), not =sqrt(4+myfunction(A1:C3)). This function returns the first ...


1

I believe that's relying on the the JSON import library by Chris Keller, found here. As its description says, To use go to Tools --> Script Editor and add the script and save. This means the entire script, not just one function from it.


3

When you have many sumif formulas in your spreadsheet, this is usually a sign you need to use query instead. The script you are currently using to fetch the sheet names can be modified so that it creates a query formula instead: function queryFormula() { var ss = SpreadsheetApp.getActiveSpreadsheet(); var formula = "=query({"; var sheets = ...


1

Using English as the main language in the Google account settings the options for the second drop-down (b) are Minutes timer Hour timer Day timer Week timer Month timer There isn't a seconds timer, so it's very likely that there is localization error. Use the Google Apps Script Issue Tracker to report it to Google.


0

As Rubén says, there's no such event built in. But you might have some (limited) success with this approach: var PROP_NAME = "lastSheetIdx"; var userProperties = PropertiesService.getUserProperties(); function didSwitchSheets(from, to) { Logger.log("Switched from " + from + " to " + to); // Your code here } function timedEventHandler() { var ...


0

At this time there isn't a trigger related to switch for one sheet to another. To learn about the available triggers in Google Apps Script, please checkout Triggers and events - Google Apps Script Guides


0

Working on the solution: ...a check that will make sure the email address that they provide actually exists in the organization... We were facing a similar situation. Being an educator we have youngsters that quite often misspell their email accounts when filling out their test forms. As a result we would end up sending their grading to the wrong ...



Top 50 recent answers are included