I have multiple sheets all with names "Pipeline History mm-dd-yyyy" with different dates. I want to search the names of the sheets for the most recent date. And then hide that sheet. I have started writing some code, but I…
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…
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…
I am new to JavaScript and I need help with App Script, please. I have a Google Sheet with three columns: Date (Data type 'Date'), Greeting and Message (both Data Type 'String'). I would like to loop through the sheet…
I am currently working a small Google Apps Script that will get Data from a from and proceed to paste some of this data in a table where it finds matching ID / invoice number. However, when these two for…
Sorry but I don't understand much about programming. I'm trying to merge two codes and make them autonomous in functioning when a new response arrives from the google form. Everything works except this part: function onEdit1(e) in this case the…
I have some data in a Google sheet that I want to convert to a .json file using Google Apps Script, however I am struggling to figure out the best way to approach it. I have an implementation already that…