These scripts were created to automate tasks for Wilson Library's "Access & Information Services" department. They are mostly used for stacks work.
Installation depends on the type of script.
Scripts that run upon the submission of a Google Form require an Installable Trigger.
- Edit Form
- Enter associated "Script editor," from vertical ellipsis in top-right corner
- Click "Triggers" (alarm clock icon on left side)
- Add trigger with settings:
- Choose which function to run = "onFormSubmit" (or name of function, if renamed)
- Choose which deployment should run = "Head"
- Select event source = "From form"
- Select event type = "On form submit"
- Edit failure notification settings as needed
The trigger serves to tell the function when to run. If it is not configured, the script is just some code attached to the Form that is never called.
There are a few ways to add a macro to a Sheet, but I typically write the script and import the function. After following those steps, the function is accessible from the "Tools > Macros" menu.
AutoHotkey (AHK) scripts only run on Windows. They can be compiled as an executable, to be run without installing AHK on the machine.
See /archive directory for obsolete scripts.
Microsoft VBA was formerly used to format pull requests, but was difficult to edit and to share between multiple machines.