I'm trying to display google sheet as a web app but returned a bad value error when trying to run it. Here is the code I used: function doGet() { return HtmlService.createTemplateFromFile('Index').evaluate(); } function getData(){ var spreadSheetId = " ";…
I'm having fun at work and building a sheet with a bunch of little scripts (read: I'm a debutant that know a little bit appscript and html code). I succeeded to make a script to make a prompt box appear…
This sample data entry web app works as expected and appends new data to the spreadsheet using the id. With minimal changes, how can the script from the HTML file be placed into a different file while keeping the same…
I'm using this code to timestamp sheet named "Verify"'s Col11 based on the first time (only) Col9 is edited. It will be cleared and reset manually, daily. The issue i'm having is editing Col9 on any sheet makes Col11 on…
I used to scrape some data from a website onto a google sheet using importhtml(URL, "table", INDEX). But recently, website changed from displaying the data in a table, to displaying it as a class = card element. Is there still…
The company I work at has been making and printing daily reports as .ods files. Historically it's been a painstaking process, so I'm trying to automate pieces of it with Google Sheets and Apps Script. The bookkeepers however still expect…
Good evening, I am trying to figure out a way to automatically delete files with duplicate filenames from a Google Drive folder. I'd like to keep the file with the oldest creation date, treat the others as duplicates, and delete…
In Google Sheets, I have been trying to copy data from Sheet "Main" to Sheets (Completed, Pending, Hold) based on selection from dropdown in column 6 named (Status) in Main Sheet. Column 6 DropDown List (Completed, Pending, Main) Once a…
The Woocommerce export to a Google Spreadsheet with the code below works. Except the format of the order total shows "99.95" instead of "99,95". This results in some faults in further processing the data. Is there a solution to fix…
I am trying to write a Google Sheets script to copy the display values from one sheet on a workbook to another sheet on a workbook. However, I am receiving the following error message, "Exception: The number of rows in…