ondemand_video   animation
Reviewed: 2021-05-28

The cell coloring functions might liven up your sheets but otherwise the other information here is for saving templates (internal use)

##sheetname and colorHeader

Use ##sheetname to populate values such as logo text or Scene Block name.
The Scene Block name becomes the title of the /view window.
Use the colorHeader function to watch 1 cell and update many cells.

Replace key values with ##sheetrawname

colorHeader description

colorColumn can be used for a column

Use getJSONForSheet to capture the template

Grab the data by chunks of 100 rows and merge the arrays in an editor, the cell length limit is 50k, and 100 rows generally works fine within this. Raw chunking is possible as well.