Series: Guide to Sheet Workers
You have a lot of power for automating your sheet. To get the most out of this feature needs some familiarity with javascript, but you can do a lot even when you don’t know what you are doing.
Anatomy of a Sheet Worker
How to write a sheet worker, and what most sheet workers have in common.
Variables – How to Name Things
A guide to naming things in sheet workers.
Arithmetic in Sheet Workers
Adding, subtracting, and other arithmetic.
What If? in Sheet Workers
How to analyse your code and manage code branching.
Arrays and Dropdowns
Create and use Arrays, which are extremely important.
JavaScript Objects
The curious connection between getAttrs, setAttrs, and custom databases – JavaScript Object!
Getting Loopy With JavaScript
If you want to do the same thing over and over, you need a loop.
Strings in Sheet Workers
Introducing Strings, what they are and how to use them.
Logging in the Browser Console
How to use the browser console, and control what appears there.
Strings, Arrays, and Loops
An example of using different techniques to solve a problem – Strings, Loops, and Arrays.
Undefined and Other Error Values
About undefined and similar “unvariables”. Avoid them when you can.
Asynchronicity and Things to Avoid With Loops
What does Asynchronicity mean and how does it affect you?
