I need to insert images at a fixed width to keep organized on the sheet. I have been testing, just getting one image where I need it, and have so far failed. My current version works sometimes; other times, it…
I have a dropdown in a project that I'm building in Google Sheets that has a search function but it takes 15 seconds or more to update the list. How can I make a search function for a large list…
Currently I have this data format on my google sheet: SKU: PORK BARREL (PILGRIMS/SOBI), QTY: 20000, PRICE PER KILO: 225 Then I want format my Data like this Then I tried to format it using appscript this code /** *…
I'm working on a project where I shall send data from my app to a google spreadsheet in 2 sheets through app script. I set up a paraphrase to secure the connection. Hkey I have a lot of data to…
I want to create a survey using Google Froms, but only limited people who have the codes can submit the form and do the survey. I have already created a list of codes inside a Google Sheet. When I try…
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…