Skip to content
My Script Store
My Script StoreEconomics of ScriptingThe Great Language Debate
More
Share
Explore

My Script Store

Bill French's Library of Published Script Blocks
Welcome to my library of Script Blocks. Listed here are all of the script blocks that I've built and openly share with various communities. There are more coming (see In Developments status) and in the coming months likely many more.

Feel free to download, test, and modify as you like. If you discover something that you like, tell others about it. If you find that you totally love a Script Block,
⁠
- I'll buy a beer and toast your success. If you cannot live without one of my creations,
⁠
or just
⁠
- I'd love to hear your story.
Published Scripts
0
Search
Script Name
K Bytes
License
Status
Screen Shot
Article/Docs
Download
Updated
Est Value
Source Request URL
1
Answer Me This
0K
MIT
In Development
image.png
​
​
3/19/2020
N/A
https://script.google.com/macros/s/AKfycbxGO0QVOYEiiBkseEh3AUSnHFMpS0OXidRtAUMTNIjj_EaFdBo/exec?appid=MyScriptStore&scriptid=1&scriptname=Answer%20Me%20This&license=MIT
2
Field Tweaker
Note - includes example tracking metric** (see below for details)
4.8K
MIT
Available
image.png
4/18/2020
$294.03
https://script.google.com/macros/s/AKfycbxGO0QVOYEiiBkseEh3AUSnHFMpS0OXidRtAUMTNIjj_EaFdBo/exec?appid=MyScriptStore&scriptid=2&scriptname=Field%20Tweaker%0ANote%20-%20includes%20example%20tracking%20metric**%20(see%20below%20for%20details)&license=MIT
3
Script Block Benchmarks
2.4K
MIT
Available
image.png
3/19/2020
$298.98
https://script.google.com/macros/s/AKfycbxGO0QVOYEiiBkseEh3AUSnHFMpS0OXidRtAUMTNIjj_EaFdBo/exec?appid=MyScriptStore&scriptid=3&scriptname=Script%20Block%20Benchmarks&license=MIT
4
Outlier Detection
4.2K
MIT
Available
image.png
3/19/2020
$291.06
https://script.google.com/macros/s/AKfycbxGO0QVOYEiiBkseEh3AUSnHFMpS0OXidRtAUMTNIjj_EaFdBo/exec?appid=MyScriptStore&scriptid=127&scriptname=Outlier%20Detection&license=MIT
5
Forecasting & Machine Learning
3.1K
CC BY-NC
Available
image.png
3/19/2020
$283.14
https://script.google.com/macros/s/AKfycbxGO0QVOYEiiBkseEh3AUSnHFMpS0OXidRtAUMTNIjj_EaFdBo/exec?appid=MyScriptStore&scriptid=128&scriptname=Forecasting%20%26%20Machine%20Learning&license=CC BY-NC
6
Airborne Search (Personal)
0K
CC BY-NC
In Development
​
​
3/19/2020
N/A
https://script.google.com/macros/s/AKfycbxGO0QVOYEiiBkseEh3AUSnHFMpS0OXidRtAUMTNIjj_EaFdBo/exec?appid=MyScriptStore&scriptid=129&scriptname=Airborne%20Search%20(Personal)&license=CC BY-NC
There are no rows in this table
6
Count
⁠
** Integrated Tracking in FieldTweaker
As you may have noticed, the Field Tweaker utility includes a simple tracking call into a Google sheet that tells me who used this utility and when. This is a good demonstration of metric reporting in script blocks. You are free to comment out this code or delete it entirely and it will not affect the performance of the utility.

This is the tracking code - feel free to employ it to gather your own metrics about script block processes.

//
// update analytics
//
// establish the cgp web service endpoint
let gcpUrl = "https://script.google.com/macros/s/AKfycbxGO0QVOYEiiBkseEh3AUSnHFMpS0OXidRtAUMTNIjj_EaFdBo/exec";
let payload = {
"userid" : session.currentUser.id,
"username" : session.currentUser.name,
"useremail" : session.currentUser.email
}
let postOptions = {
method: "post",
headers: {
'Accept' : 'application/json',
},
body: JSON.stringify(payload)
}
const postResults = await fetch(gcpUrl, postOptions);
// const jsonPost = await postResults.json();

Related Docs
A framework for radical focus.
$10k Work: How to increase your productivity using the magic of leverage
Khe Hy
Three simple tips to ensure you're driving results from written documents.
Two-way writeups: Coda’s secret to shipping fast
Lane Shackleton
A tutorial on how you can sync and analyze your Peloton workout stats into Coda with custom dashboards using the unofficial Peloton API.
Peloton Analytics Tool for Workout Stats [+Template]
Al Chen
Mental Health Awareness Month
Jamie Forseth
Four Myths of Bundling
Shishir Mehrotra
OTF Planner (otfplanner.com)
Kenny
This generator randomly pulls from my collection of favorite quotes, just over 397 as of February 2022. Come back every so often to copy new additions.
Random Quote Generator
Mark Davis
SpotRacer Database
kev null
Founders Mindset Bootcamp Shared
Nathalie Rafeh
Framework for better 1:1 meetings & tracking progress to goals
1:1 & Career Development Template
Eric Glick
My guide to achieving and maintaining Inbox Zero.
The Inbox-Zero Challenge: How long can you keep up your streak?
Shishir Mehrotra
Here's a list of amazing people affected by the recent layoffs.
Hiring List Template
SiNing Chan
BlockSplit Info
Block Split
Use this doc to easily make and manage the guest list for your next big event.
Easy RSVP Tracker with the Gmail Pack
Kay Diaz-Ferrigno
Want to print your doc?
This is not the way.
Try clicking the ⋯ next to your doc name or using a keyboard shortcut (
CtrlP
) instead.