Skip to main content
The following information will assist in the creation of widgets that comprise a sheet template calculation.
This information discusses the raw JSON files, but most of this can now be done in the template editor. Nevertheless, most of this information still remains relevant, as it is the same information that you enter, whether youโ€™re entering it in the editor or directly into the JSON file. You just no longer need to remember the exact syntax and names for every key in a widget.

Key Components

Heading Data

  • Sheet Headers - All the stuff at the top of the sheet that defines the template name, etc. (Documentation coming soon)

Upgrade Mapping

  • Upgrade Mappings - Equations for converting old widgets and sharedTables into the current version, when a user upgrades their template

Presets

  • Module Presets - A set of defaultValues which a user can select for a given template

Widgets

  • Section Widget - The boxes with blue heading text
  • Input Widget - Any plain text box you type into
  • Equation Widget - Any plain calculated number
    • Special โ€œMembersโ€ Equation Widget - For exporting data to Member Schedule (Documentation coming soon)
  • Lookup Widget - Drop-down menus with data set in the widget
  • Table Widget - The big tables on sheets
  • Remote Widget - Invisible to users, but essential widget for using a finite element analysis solver
  • Diagram Widget - Creates various types of pretty diagrams
  • Image Widget - Shows an image, possibly based on conditions
  • Map Widget - Shows a Google Map at a given lat/lon
  • Framing Widget - When data is imported via the framing tool, this shows a diagram of the current member within the building frame