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 they used to achieve this is listed in the code section: This code doesn’t seem to work
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 built so far (please no laughing)!…
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 be able to automatically calculate
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 inserted into
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”:”180761″,”status”:”Bad Request”,”code”:400,”error”:{“code”:18,”message”:”Validation error has occurred (missing required field/paramet… (use muteHttpExceptions option to examine full response) (line 171,
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.org1 using