Template Development Overview
Learn about creating widgets and templates for ClearCalcs sheet calculations
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.
Upgrade Mapping
- Mapping - Equations for converting old widgets and sharedTables into the current version, when a user upgrades their template
Presets
- Preset - 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
- Lookup Widget - Drop-down menus with data set in the widget
- Shared Lookup Widget - Drop-down menus referencing pre-written sharedTables
- Member Selector
- 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