I would like to implement a function that allows characters and numbers to be entered into a spreadsheet, and if nothing is entered using GAS, a message box will be displayed. Therefore, I would like to use the following function…
I have an array of numerical values in a google sheet that all need to have the sign changed on them using app script. For example, 6000 becomes -6000 and so on down the line. I am trying to use…
I am writing an App Scripts code to write events from my spreadsheet into my Google Calendar, but I want to save the Event ID on the right of the range. I can get the event id no problem, but…
How to get the whole range of the onEdit(e) by Google Sheets script? I have tried the following script: var sheet = spreadsheet.getActiveSheet(); function onEdit(e){ var row = e.range.getRow(); var column = e.range.getColumn(); sheet.getRange('A1').setNote(range.getRow() + ',' + range.getColumn()); } Well,…
I'm trying to fetch JSON data from my API to import to Google Sheets using Google Apps Script. Everything is working as expected, except for when I'm trying to map the object, the result array returns undefined objects. Here's my…
I used this code to parse my webrequest response: for (var [key,val] of Object.entries(jsonObj)) { console.log("Key="+key); console.log("Value="+val); } Its working for one of my url but for another one I get: {members=[Ljava.lang.Object;@3e0dc74, list_id=xxxxx, total_items=2.0, _links=[Ljava.lang.Object;@610c2a56} The response is ok but…
I need an array with the boolean values, but instead, it gives me the variable name. Here is a simplistic example: I declare variable to check for match to other data, gives boolean results. var usatest = new RegExp("USA").test(continent); //this…
I want to exactly match the key from an Object to an element in an array and replace the match in the array with the key value. I have Arr = [ 'Saturday', 'niCCCght', 'plans,', 'CCC' ] Obj = {…
It was working fine up until yesterday, its a script to take in one number and see how many combinations another set of numbers will add up to that one number. It is producing a blank field in column J,…
when I save each google form entry in my linkde google sheet, it adds a column with the response's timestamp. What I see in that cell is something like this "17/01/2024 20:55:23". When I print the content of this cell…