Skip to content

Instantly share code, notes, and snippets.

View rheajt's full-sized avatar
🏠
Working from home

jordan rhea rheajt

🏠
Working from home
View GitHub Profile
@rheajt
rheajt / Code.gs
Created June 13, 2017 16:30
google apps script code to append an image to a document with the file id
function onOpen() {
DocumentApp.getUi()
.createMenu('ID-TO-IMAGE')
.addItem('Run', 'runIdToImage')
.addToUi();
}
function runIdToImage() {
var doc = DocumentApp.getActiveDocument();
@rheajt
rheajt / Code.gs
Created August 1, 2017 08:16
examples of simple triggers with google apps script
/**
* These simple triggers are available in Sheets, Docs, and Forms
* Most of this information can be found:
* https://developers.google.com/apps-script/guides/triggers/events
*/
function onOpen(e) {
// {
// authMode: 'LIMITED',
// source: 'Spreadsheet' || 'Document' || 'Form',
// user: 'User'
@rheajt
rheajt / Code.gs
Last active November 16, 2022 17:04
Google Apps Script file-open dialog boilerplate: https://developers.google.com/apps-script/guides/dialogs#file-open_dialogs
/**
* Creates a custom menu in Google Sheets when the spreadsheet opens.
*/
function onOpen() {
SlidesApp.getUi().createMenu('Picker')
.addItem('Start', 'showPicker')
.addToUi();
}
/**
{
"$schema": "http://json-schema.org/draft-04/schema#",
"type": "object",
"properties": {
"entries": {
"type": "array",
"items": [
{
"type": "object",
"properties": {
@rheajt
rheajt / Code.gs
Created June 14, 2017 15:38
google apps script to open a new website in a new window
function openTab() {
var selection = SpreadsheetApp.getActiveSheet().getActiveCell().getValue();
var html = "<script>window.open('" + selection + "');google.script.host.close();</script>";
var userInterface = HtmlService.createHtmlOutput(html);
SpreadsheetApp.getUi().showModalDialog(userInterface, 'Open Tab');
}
function doGet(e) {
if(!e.parameters.sheetId) {
return HtmlService.createTemplateFromFile('Start').evaluate().setSandboxMode(HtmlService.SandboxMode.IFRAME);
} else {
var html = HtmlService.createTemplateFromFile('Viewer');
//set variable of sheet id to post in hidden input field for async request when page loads
html.sheetName = SpreadsheetApp.openById(e.parameters.sheetId).getName();
html.sheetId = e.parameters.sheetId;
@rheajt
rheajt / index.html
Last active August 30, 2021 21:24
[Publish Google Sheet to the Web] easily turn your google sheets into a JSON data source #gaspowered
<ul></ul>
@rheajt
rheajt / Code.gs
Last active January 14, 2021 16:38
google apps script convert column number to letter
function columnToLetter(column, row) {
var temp, letter = '';
while (column > 0) {
temp = (column - 1) % 26;
letter = String.fromCharCode(temp + 65) + letter;
column = (column - temp - 1) / 26;
}
return letter + row;
}
@rheajt
rheajt / Code.gs
Last active January 6, 2021 21:36
create data validation cells with either named ranges or columns from a sheet in Google Sheets
function onOpen() {
SpreadsheetApp.getUi()
.createMenu('MULTI DATA VALIDATION')
.addItem('Open', 'openSidebar')
.addToUi();
}
function onInstall() {
installEditTrigger();
onOpen();
@rheajt
rheajt / RosterMaker.gs
Created June 20, 2017 14:33
google apps script to create multiple sections programmatically from a spreadsheet
function rosterMaker() {
//spreadsheet id of the rosters
var SHEET_ID = FormApp.getActiveForm().getDestinationId();
var ss = SpreadsheetApp.openById(SHEET_ID);
var form = FormApp.getActiveForm();
//get only the sheets with 'Roster' in the title
var sheets = ss.getSheets()
.filter(function(sheet) {return sheet.getName().match(/Roster/gi);});