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
I cannot find any property receiving the currently for the user displayed calendar week with google apps-script here What I want to do is: Extract the start and
I pull data from a Google Event Calendar. The events include multiple point of contact e-mails (Primary, Secondary, etc.) I am currently able to collect ALL of
I have a google sheet like this I Need to make a google appscript webapp like below with the above sheet. only the price field need to be editable. When it is
We have scales for which we upload data based on a Google sheet that we maintain. The Google Sheet translates the data into the correct configuration and we exp
I want to list all videos of a YouTube channel in Google Sheets and see statistics if possible. How to achieve this with Google Apps Script?
How can one create an Apps Script function to sum only numbers given a string. I've been able to do this using this regular formula within Google Sheets: =SUM(S
I am trying to import a csv file to google sheets via google appscript. everything works well except in the last few rows the data is being copied after skippin
I am trying to import a csv file to google sheets via google appscript. everything works well except in the last few rows the data is being copied after skippin