Skip to content
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
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
12/6/2022
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
12/6/2022
$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
12/6/2022
$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
12/6/2022
$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
12/6/2022
$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
12/6/2022
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.
This is not the way.
Try clicking the ⋯ next to your doc name or using a keyboard shortcut (
CtrlP
) instead.