Eric Koleda erickoledadevrel
erickoledadevrel
/ zendesk.ts
Created
March 6, 2024 14:56
Using the password grant to connect to the Zendesk API in a Coda Pack
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| import * as coda from "@codahq/packs-sdk"; | |
| export const pack = coda.newPack(); | |
| const ClientId = "..."; | |
| const ClientSecret = "..."; | |
| pack.addNetworkDomain("zendesk.com"); | |
| pack.setUserAuthentication({ | |
| type: coda.AuthenticationType.Custom, |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| import * as coda from "@codahq/packs-sdk"; | |
| export const pack = coda.newPack(); | |
| // TODO: Set domain and API key. | |
| const ProjectDomain = "<subdomain>.supabase.co"; | |
| const ApiKey = <apikey>"; | |
| const ProjectUrl = `https://${ProjectDomain}`; | |
| pack.addNetworkDomain(ProjectDomain); |
erickoledadevrel
/ checkAndHide.gs
Last active
April 9, 2022 16:53
Google Apps Script code to hide a row when a checkbox is checked.
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| /* | |
| * Copyright 2019 Google LLC. | |
| * SPDX-License-Identifier: Apache-2.0 | |
| */ | |
| var CHECKBOX_COLUMN = 'B'; | |
| function onEdit() { | |
| var range = SpreadsheetApp.getActiveRange(); | |
| if (range.getA1Notation().split(/\d/)[0] == CHECKBOX_COLUMN && |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| /** | |
| * @license | |
| * Copyright 2019 Google LLC | |
| * | |
| * Licensed under the Apache License, Version 2.0 (the "License"); | |
| * you may not use this file except in compliance with the License. | |
| * You may obtain a copy of the License at | |
| * | |
| * https://www.apache.org/licenses/LICENSE-2.0 | |
| * |
erickoledadevrel
/ moveToCalendar.gs
Last active
November 16, 2023 07:02
Moving events from one calendar to another, using Google Apps Script
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| /** | |
| * Move events with a given title from your primary calendar to another calendar. | |
| * You must enable the Calendar Advanced Service: | |
| * https://developers.google.com/apps-script/guides/services/advanced#enabling_advanced_services | |
| */ | |
| function moveEvents(eventTitle, fromCalendarName, toCalendarName) { | |
| var fromCalendarId = CalendarApp.getCalendarsByName(fromCalendarName)[0].getId(); | |
| var toCalendarId = CalendarApp.getCalendarsByName(toCalendarName)[0].getId(); | |
| var now = new Date(); |
erickoledadevrel
/ downloadFileRange.gs
Created
August 9, 2018 16:22
Downloading a portion of a Drive file in Apps Script.
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| function downloadFileRange(fileId, startByte, endByte) { | |
| // Mention DriveApp in a comment to ensure the Drive scope is requested. | |
| // DriveApp.getRootFolder(); | |
| var url = 'https://www.googleapis.com/drive/v3/files/' + | |
| fileId + '?alt=media'; | |
| var response = UrlFetchApp.fetch(url, { | |
| headers: { | |
| Authorization: 'Bearer ' + ScriptApp.getOAuthToken(), | |
| Range: 'bytes=' + startByte + '-' + endByte | |
| } |
erickoledadevrel
/ dynamic_docs.js
Last active
April 9, 2022 16:48
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| function onOpen() { | |
| DocumentApp.getUi().createMenu('Demo') | |
| .addItem('Select Spreadsheet', 'selectSpreadsheet') | |
| .addItem('Update Data', 'updateData') | |
| .addToUi(); | |
| } | |
| function selectSpreadsheet() { | |
| var result = DocumentApp.getUi().prompt('Enter the ID of the spreadsheet:'); | |
| var spreadsheetId = result.getResponseText(); |
erickoledadevrel
/ UnmergedRanges.gs
Last active
February 20, 2023 11:58
[Apps Script] Getting the unmerged ranges within a range
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| /** | |
| * Gets all the unmerged ranges within a range. | |
| * @param {SpreadsheetApp.Range} range The range to evaluate. | |
| * @returns {SpreadsheetApp.Range[]} The unmerged ranges. | |
| */ | |
| function getUnmergedRanges(range) { | |
| if (!range.isPartOfMerge()) { | |
| return [range]; | |
| } | |
| var mergedRanges = range.getMergedRanges(); |
erickoledadevrel
/ AppsMarketplaceSignIn.html
Created
April 22, 2016 18:42
Showing how to use the Google Sign-in JavaScript library with Google Apps Marketplace.
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| <html> | |
| <head> | |
| <title>GAM Sample App</title> | |
| <script src="https://cdnjs.cloudflare.com/ajax/libs/URI.js/1.17.1/URI.js"></script> | |
| <script src="https://apis.google.com/js/platform.js?onload=init" async defer></script> | |
| </head> | |
| <body> | |
| <h1>GAM Sample App</h1> | |
| <p id="message">Loading...</p> | |
erickoledadevrel
/ Timezones.gs
Last active
July 8, 2020 11:42
Some examples showing how to work with timezones in Apps Script.
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| // Setup: Spreadsheet in Pacific time, Script in Eastern time, Calendar in Mountain time. | |
| // Sample spreadsheet: https://docs.google.com/spreadsheets/d/1neePK1YPKMKnVwI8dld0HSJjI1kSFPpcY8g7kG8xG4U/edit#gid=0 | |
| // A2 = 3/1/2016 9:00 AM, B2 = 3/1/2016 10:00 AM | |
| /** | |
| * The dates and times in the spreadsheet refer to exact moments in time, and the clock | |
| * on the wall may show a different time. | |
| */ | |
| function copyMoment() { | |
| var ss = SpreadsheetApp.getActive(); |
NewerOlder