My Script Store

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,

send me a $5 tip⁠

- I'll buy a beer and toast your success. If you cannot live without one of my creations,

tip me whatever you want⁠

or just

drop me a note⁠

- I'd love to hear your story.

Published Scripts

Published Scripts

Script Name

K Bytes

License

Status

Screen Shot

Article/Docs

Download

Updated

Est Value

Source Request URL

Answer Me This

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

Field Tweaker Note - includes example tracking metric** (see below for details)

4.8K

MIT

Available

ARTICLE

DOWNLOAD

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

Script Block Benchmarks

2.4K

MIT

Available

ARTICLE

DOWNLOAD

12/6/2022

$298.98

https://script.google.com/macros/s/AKfycbxGO0QVOYEiiBkseEh3AUSnHFMpS0OXidRtAUMTNIjj_EaFdBo/exec?appid=MyScriptStore&scriptid=3&scriptname=Script%20Block%20Benchmarks&license=MIT

Outlier Detection

4.2K

MIT

Available

ARTICLE

DOWNLOAD

12/6/2022

$291.06

https://script.google.com/macros/s/AKfycbxGO0QVOYEiiBkseEh3AUSnHFMpS0OXidRtAUMTNIjj_EaFdBo/exec?appid=MyScriptStore&scriptid=127&scriptname=Outlier%20Detection&license=MIT

Forecasting & Machine Learning

3.1K

CC BY-NC

Available

ARTICLE

DOWNLOAD

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

Airborne Search (Personal)

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

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.