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
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();

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.