Contents
alternate_email

  ondemand_video   animation
Reviewed: 2021-03-28
Addon Set Server(red) Button sets the Server Target
Addon Refresh Button refreshes data from the spreadsheet
Addon Refresh(busy) Button green means please wait patiently

Sheet: Configuration

Purpose: Configuration View data storage
Origin: usually generated - manual edit is ok
Addon Contextual Help Overview
[Target Server]: Firebase Project ID with API deployed
[Token Token]: Token for API
[Target Project]: Default Project [name] in 'Projects' list
[Parent Spreadsheet]: Document ID to load deployment options from (more below).
Configuration Sheet Example

Note on manual editing with sidepanel open

- use Addon Refresh Button to refresh the data after editing.
Please wait for Addon Refresh(busy) Button to turn back to gray.

Sheet: Projects

Purpose: Projects View data storage
Origin: usually generated - manual edit is ok
Addon Header Overview
[Project Name]: Title of project (unique to server)
[Asset Ranges]: Comma delimited list of ranges (can be remote: with spreadsheetid||||sheet!range)
[Circuit Ranges]: Comma delimited list of ranges with CSV - 2nd processed
[Catalog Ranges]: Comma delimited list of ranges with CSV - last processed
[Flags]: "Ignore" skips this line on [Deploy All] - "Remove" removes the project from the target server
Projects Sheet Example

Note on manual editing with sidepanel open

- use Addon Refresh Button to refresh the data after editing.
Please wait for Addon Refresh(busy) Button to turn back to gray.
=getDataRangesForSheet(sheetName) - detects the data tables and returns the ranges for a sheet.
For more: Sheets Custom Functions

Sheet: Deploy Options

Optional

Purpose: Available Servers for Configuration View
Origin: manual creation
Location: from parent spreadsheet in Configuration - otherwise local
[deployrange]: Data Range for list
Range: Servers
Deploy Options Sheet Example Required range (local or parent): 'Deploy Options'!A1:A2
  this specifies where to find the Data Table for servers
[server]: Firebase instance/project name
[url]: Public url if it exists
[token]: token (optional)
[description]: displays in Configuration View
Note: If Parent Spreadsheet is specified in Configuration the addon will always and only look there for the Deploy Options sheet.