I have a Google apps script project which I use as a web application to save some data gathered from a web page (JavaScript only) to My Google sheets (think of
With this code I can send the events directly to google calendar from google sheets. The start date and end date are on two different columns
Does anyone has experience in convert a batch of .docx file, stored in Google Drive, to Google Docs format? I read the solution posted 3 years ago by Youssef, b
I have used importhtml function for google sheets many times and successfully but sometimes I have had no luck in getting it to work. I am doi
My understanding from the docs is that Session.getTemporaryActiveUserKey() changes for a user every 30 days. In my past experience using it, this was true but o
How to check if a cell in google sheet contains $ (USD dollar) currency or Rs. (Pakistani Rupees) currency to calculate two different currencies total?
I have a spreadsheet of data where I pull data from an array of data. After I declare the data, I run the code and it sends a message to slack using their block
I'm trying to use UrlfetchApp to send a request to a page. Request is good. But returning <p>Your browser is currently set to block cookies. Please enable
I am trying to count the maximum number of rows in other google sheets. Actually, Each spreadsheet has a number of tabs and I want the maximum row number of all
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