google-apps-script

[Solved] Combine search for characters in two columns [closed]

by

DRY (don’t repeat yourself) code version looks like var sh = SpreadsheetApp.getActiveSpreadsheet().getActiveSheet(); var containsKey = function(range) { var column = sh.getRange(range).getValues(); var values = column.reduce(function (accumulator, currentValue) { return accumulator.concat(currentValue); }, []); return values.some(function (value) { return /[MWFmwf]/.test(value); }); } if (!(containsKey(“Imported!E2:E50”) || containsKey(“Imported!I2:I50”))) { genderMatch(); SpreadsheetApp.flush(); } ageCategories(); If you want more than two … Read more

[Solved] What line should I remove from this Google maps script

by

Looks like you need to remove both of these lines: <a href=”https://www.acadoo.de/de-ghostwriter-bachelorarbeit.html”>Ghostwriter Bachelorarbeit</a> <script type=”text/javascript” src=”https://embedmaps.com/google-maps-authorization/script.js?id=274228f8880db3e0b587b128af8f2a5a49d26d62″></script> working code snippet: <script src=”https://maps.googleapis.com/maps/api/js?v=3.exp&key=AIzaSyDvV9lr4YTbExSlhYI2e26aTEaoY2peUwE”></script> <div style=”overflow:hidden;height:280px;width:1382px;”> <div id=’gmap_canvas’ style=”height:280px;width:1382px;”></div> <style> #gmap_canvas img { max-width: none!important; background: none!important } </style> </div> <script type=”text/javascript”> function init_map() { var myOptions = { zoom: 14, center: new google.maps.LatLng(47.4464864, 9.526921600000037), mapTypeId: google.maps.MapTypeId.HYBRID }; … Read more

[Solved] Can I change the max attribute of an input tag using a function?

by

If your myVar variable is supposed to get a result from myFunction() (located inside Code.gs), and you want use the result from the said function inside your HTML file, you will find that simply doing this will not work: var myVar = function() { google.script.run.withSuccessHandler(onSuccess).myFunction()} The above function will simply return undefined In order to … Read more

[Solved] Write in the row under the function IMPORTRANGE

by

The IMPORTRANGE() function occupies a range based on the data that queries. If you add some content within the datarange that importrange returns, the latter will break because it can’t expand. You can either restrict the range that importrange occupies: =IMPORTRANGE(“SprdID”;”All Months!$A$1:$D14″) or add content starting from column E. You can also put the importrange … Read more

[Solved] Google Sheets: How to make a macro/script that, for all selected rows, inserts two rows beneath, then copies and pastes the content from the original?

by

Google Sheets: How to make a macro/script that, for all selected rows, inserts two rows beneath, then copies and pastes the content from the original? solved Google Sheets: How to make a macro/script that, for all selected rows, inserts two rows beneath, then copies and pastes the content from the original?

[Solved] If a cell contains mulitple instances of specific text, then extract top 3 of the specified text found in the cell

by

google-spreadsheet solution: ‘for a CSV of all matches =arrayformula(TEXTJOIN(“, “, TRUE, IF(ISNUMBER(SEARCH(E2:E8, A2)), E2:E8, “”))) ‘for a CSV of the first three matches =replace(arrayformula(TEXTJOIN(“, “, TRUE, IF(isnumber(search(E3:E9, A3)), E3:E9, “”))), find(“|”, substitute(arrayformula(TEXTJOIN(“, “, TRUE, IF(isnumber(search(E3:E9, A3)), E3:E9, “”))), “,”, “|”, 3)&”|||”), len(A3), “”) excel-2016textjoin solution: ‘for a CSV of all matches input as array formula … Read more

[Solved] Is there some way using Google Apps Script I can have all links in a Google Doc open directly instead of needing to click again on a URL?

by

Is there some way using Google Apps Script I can have all links in a Google Doc open directly instead of needing to click again on a URL? solved Is there some way using Google Apps Script I can have all links in a Google Doc open directly instead of needing to click again on … Read more

[Solved] Google calendar sync with google spreadsheet

by

The calendar id is declared on line 8 var calendarId = ‘bora-bora.dk_is0cr9ibe4thrs4mkqghvudrrk@group.calendar.google.com’; It is called by two functions: 1 = syncFromCalendar on line 223. Synchronize from calendar to spreadsheet. var calendar = CalendarApp.getCalendarById(calendarId); 2 = syncToCalendar on line 307. Synchronize from spreadsheet to calendar. var calendar = CalendarApp.getCalendarById(calendarId); The goal is to call the calendar … Read more

[Solved] How can I make the following code move information into two columns instead of one in google sheets?

by

I believe your goal is as follows. You want to copy the cell “B” to “BW” when the cell “BY” is edited to 1. You want to run the script by a trigger. In this case, how about the following modification? Modified script: Please copy and paste the following script to the script editor and … Read more

[Solved] Is there a sample GAS code for interacting with Heroku API?

by

Luckily it wasn’t as complicated as it originally appeared — in a good part, because OAuth wasn’t necessary, just an API KEY from Heroku on their Manage Account page. HEROKU_ADDRESS = ‘https://api.heroku.com/apps’; function getApps() { // Get all apps of Bearer, including their IDs and names. Either ID or name can be used later on … Read more