=== 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
I am needing to copy all data in a row (including formulas and formatting) to another tab (when a checkbox is ticked), and then I want to clear the contents of
I am needing to copy all data in a row (including formulas and formatting) to another tab (when a checkbox is ticked), and then I want to clear the contents of
I am trying to run the code of this post, : Google Script: Play Sound when a specific cell change the Value with the recommendation of Rob Blakemore Could some
How do I get page number, which is modified (deleting/adding content) in Google doc, Google Slide in last modification time? I have used Google drive revision
I have mild general programming knowledge but know basically nothing about google apps scripts specifically. I am trying to create dynamic page breaks in googl
I am learning to use AutoHotKeys and I have a repetitive task that happens on every email. But it involves a different program outside of google. So I am wonder
Protecting a range in google sheet also locks the cell's column width. I would like to make a cell read-only but still allow the user to resize the column widt
I have 3 inputs and from where by click in a button get those input value and create a Google Visualization dynamic Pie Chart depend on those value . I have mad
OK, I think web Gmail is being screwy. I run a Google apps script that in part adds my "To-do" label to any thread I manually star, then archives and unstars it