I’m trying to implement this script to find the current date on all viewable sheets (Not Hidden) and move to the active date range (today) on whichever tab it’s on upon open. I found this thread but it’s now locked, https://productforums.google.com/forum/#!topic/docs/NiPjCPUOx3M The script t…
Tag: google-apps-script
How to add an API Key to a UrlFetchApp in Google Apps Scripts
Solved Thanks to Dimu Designs for helping out. The following works. Problem I’m trying to use Google App Scripts within Google Sheets to call the external Fortnite API to request player data. The bit I’m stuck on how to add an API Key as a header when passing the request. This is what I’ve b…
Automatically replace dots with commas in a Google Sheets Column with Google Script
I have a WooCommerce store, which is connected with Zapier to a Google spreadsheet. In this file, I keep track of the sales etc. Some of these columns contain -obviously- prices, such as price ex VAT, etc. However, for some reason the pricing values are stored in my spreadsheet as strings, such as 18.21. To b…
Creating a JSON object from Google Sheets
I am trying to learn AppScript and I am using Google Sheets as an example. I want to create a simple JSON object using some data populated in the Sheet. Table Example Name ID Price Qty ABC 123 100 1 DEF 342 56 2 HIJ 233 90 3 IJK 213 68 5 I want the JSON out to be something
Google Script – get data from Gmail into Sheet
I have been looking around here on SO and on Google, but I cannot find anything that is working. So when I am running my code below, I am getting the result on the image. I want to extract data from the newest/most recent thread in mails that have a specific label. However, in my Gmail, I only have the
Get last value from an array using Google Apps Script
I need to get last value from an array and I keep getting this error when I use slice TypeError: Cannot find function slice in object Sun Jul 23 2017 00:00:00 GMT+0100 (BST). (line 15, file If I use length -1 I get NaN. This is the code I am using it. … and this is the table full table
How can I create dynamic components with Google App Scripts for Google Sites?
I am trying to create dynamic app script components that can be added into my site with dynamic data for each instance of the script. I tried doing parameters, but I am not sure if that’s the best way to approach this. For example, I want to create an image script that be loaded with dynamic links, and …
How can I see the full server response for this API error message in Google Scripts?
I’m getting an error response from the API that I’m using, but Google scripts seems to truncate the message. How can I see the full message in Google scripts? This is the message: Request failed for https://api.myintervals.com/task/ returned code 400. Truncated server response: {“personid…
How can I get color from CalendarEvent object on google apps script?
I want to get the color(red) below the picture. enter image description here I use next code, but I don’t know next step. run main function. Answer First of all you need to enable the Advanced Google Services. Please see here description how do that. Then the following code will do the job
How to direct user-uploaded files to a specific Google Drive folder
I am a programming novice, and turn to different codes and apps when I am faced with a problem and need a unique solution. I am an elementary computer teacher, and was looking for a way for students to upload files from home or from their phones, and into my Google Drive account. I found a solution on labnol.…