Skip to content

Instantly share code, notes, and snippets.

View EwenH's full-sized avatar

Ewen Hill EwenH

  • Internet Development Australia
  • Melbourne, Australia
View GitHub Profile
@tanaikech
tanaikech / submit.md
Last active August 16, 2023 23:30
Selecting Files in Google Drive using Select Box for Google Apps Script

This is a sample script for selecting files in Google Drive using HTML select box for Google Apps Script.

Feature

Feature of this sample.

  • It is a simple and space saving.
  • When the folder is selected, the files in the folder are shown.
  • When the file is selected, the ID of file is retrieved. Users can use this ID at GAS.
  • When a folder is opened, all files in the folder are cached. By this, the second access of the folder is faster.
  • It doesn't retrieve all files in Google Drive at once, so the read of files from Google Drive becomes the minimum necessary.
@ianlewis
ianlewis / csv_import_magic.js
Last active February 3, 2023 13:16
A Google Apps Script for importing CSV data into a Google Spreadsheet.
// vim: ft=javascript:
/*jslint sloppy: true, vars: true, white: true, nomen: true, browser: true */
/*global SpreadsheetApp, UiApp, UrlFetchApp, Utilities */
/*
* A script to automate requesting data from an external url that outputs CSV data.
*
* Adapted from the Google Analytics Report Automation (magic) script.
* @author nickski15@gmail.com (Nick Mihailovski)
* @author ianmlewis@gmail.com (Ian Lewis)
*/
@toronya
toronya / Decoding URL Query String Parameters by Lotus Notes Agent Script.vb
Last active May 27, 2022 19:35
Decoding URL Query String Parameters by Lotus Notes Agent Script.
Option Declare
'#-------------------------------------------------------#
'# Decode URL Query String Parameters by Lotus Notes Agent Script.
'#
'# ex. http://example.com/test.nsf/agentname?openagent&title=%E3%83%88%E3%83%83%E3%83%97%E3%83%9A%E3%83%BC%E3%82%B8
'# => arg_decoded = "トップページ"
'#-------------------------------------------------------#
Sub Initialize
Dim session As New NotesSession
Dim db As NotesDatabase