Google Drive is quite impressive for a web app, but it seems to be optimised for search, not spatial navigation so it's painfully slow for myself and colleagues
I have a Google Sheet where I am tracking baseball stats for my High School Baseball team. I have the script setup for every time a Hit Error or Run is recorded
I am attempting to come up with a live leaderboard for my local club using the PDGA's (Professional Disc Golf Association) API. I am writing a Google Apps Scrip
I have an Appsheet app, for which I am trying to get the Google File ID of an image that I have taken through the app. When the image is taken in the app, it is
I have a very simple Dropdown on Google Sheets that is working perfectly. Basically when I select an item from the dropdown, it will output that same item on an
I've been switched over to the new Google Apps Script IDE. I used to be able to click FILE > PROJECT PROPERTIES to access global properties for files I cann
When I run a script (UPDATE_PRODUCT_DATA) through the editor it runs fine. When it is run through a Trigger it fails. It is failing at getFilesByName – b
In google apps script, with onEdit trigger, how do I get the old values of all the cells if the edited range has multiple cells? In the Event object documentati
I have multiple sheets with different dates and different calendar ids. The intention is to have the script go over each sheet and import it in the calendar wit
=== Answer added in code === please could you help me resolve this : How get form.test[j] work in the Apps Script code of the form submit.Input name are : test1
EDIT*** Modified the question now that I have a proper source... I am trying to copy a communication log to Google Sheets and don't know enough about scripting
After some searching I found this code to get a sidebar of all tabs (workbooks) in Google Sheets as a hyperlink. I am looking to add two functionalities to this
In Google Sheets, is there a way to calculate the width, in pixels, of a piece of text given a font and a font size? Excel has a PixelWidth function, but I didn
I have made two Google spreadsheets. One is parent sheet and another is a child sheet that imports data from parent sheet. This data is imported using a standal
I am trying to figure out the official code sample of Google: /** * The event handler triggered when the selection changes in the spreadsheet. * @param {Event
I was using the below google app script to delete emails automatically from my trash folder. for some reason, this is no longer deleting the emails however the
I have a google spreadsheet addon, Formula Tracer Sidebar, published on the Google workspace marketplace. Every once in a while, the following error entry is in
I'm using this script I found and it's working fine in inserting a new row, I just add a new line to clear the row clearContent(). I wanted to modify this so th
I have the following trigger setTrigger() set for when a Google Form is submitted. For testing purposes I created a simple function triggerFunction() that creat
I am trying to develop a navigational menu being referenced to different pages in my app. am using Materialize css as a ui and placed the nav codes in a separat