When clicking "button1" I would like the code to check the First Cell (Column A) of Rows 38-58 and hide the Row if the corresponding cell is empty and show if i
Good evening everyone, forgive the trouble, I tried to do a "search" on the site but I could not find the answer to my problem so I thought of opening a new dis
I got responses from Google form into Google Spreadsheet. I want to filter out the "Weekend" and "Workday". For the "Weekend" days, I only want to select the co
Currently with my 3rd party video conferencing plugin, When user clicks on Google calendar there is popup for scheduling event and in that they can select custo
Please Help, how to convert comment's value to cell's value using google script? This is the comment, and i want to getValue that comment, and setValue to each
function setWebhook() { var url = telegramUrl + "/setWebhook?url=" + webAppUrl; var response = UrlFetchApp.fetch(url); var obj = JSON.parse(response) Lo
I have a Spreadsheet with about 3000 rows which are grouped by order number. I'm trying to build an macro to: remove all groups multisort all rows recreate gr
I want to retrieve the name of a cell having his range. this is the range : var rangeOfCell = sheet.getRange(100,5); I want to know how to get his native(A1, A
Simple contact web form. I cannot figure out why it does not work as intended. On open sets up a menu, allows me to select a modal, non-modal or sidebar for for
getLastRow() not working in my script. I am trying to return the last row that has data. But since the spreadsheet has empty rows below the rows filled with dat
I am trying to do something and I am almost there but I have been scratching my head on a 'length' issue for quite some time now. What I want to do : Get data f
I am unable to find what is the expiry of property we set using Properties.setProperty(key, value) method of Class PropertiesService. I know we can delete it us
Intuitively, I set a on form submit function in the form's script editor and set the trigger accordingly. function onSubmit(e) { console.log(e); } However, th
I'm using that in a cell but I have a lot of problems to get the information because many times the sheet is "loading" and does not load the information =QUERY(
I need to have a Google Form that returns the result of variable2 depends on the result of variable1. The code runs successfully but the variable 2 does not cha
I have been trying to translate text from HTML code. Here is an example: var s = '<span>X stopped the</span><icon></icon><subject>
It seems I can't parse a json file in a Document script despite it's possible via a DriveApp script. Here is a reproducible example : edit a json valid file and
I try to publish an Editor Add-on for Google Sheet into the workspace marketplace. But I'm struck on the review. With this message : The App doesn’t meet
I have a spreadsheet that I would like to create an app script function to clear data/set values from certain cells. It also needs to work up to the last row, a
I have a form in a web app where you can upload an image, and then i send a POST call to a GAS script. Then in the GAS script i save the image in a Google drive