Calculated Fields
The Calculated Field lets you automatically generate a number based on other fields in your inspection template. It’s useful when you need to do basic math—like totals, differences, or conversions—on the spot during an inspection.
You can also use the result to trigger scoring, flags, or color coding based on the value.
✅ You can apply scoring or flags to the result of a calculated field ❌ This won’t calculate the overall inspection score (just one part of it)
What You Can Do
- Add, subtract, multiply, or divide values from other fields
- Show real-time results during the inspection
- Apply scoring or rules if the result is too high, too low, or in a certain range
Common Examples
Use Case | What It Does |
|---|---|
Total Material Usage | (Material A + Material B) shows total amount used across multiple inputs |
Load Efficiency | (Total Weight ÷ Load Capacity) calculates load percentage for safety validation |
Time Variance Check | (Planned Duration – Actual Duration) highlights schedule overruns |
Area Coverage | (Length × Width) automatically calculates total surface area |
Output Variance | (Target Output – Actual Output) flags shortfalls in performance |
How to Set Up a Calculated Field
1. Add the Field to Your Template
In the Template Builder, go to Advanced Controls and drag in the Calculated Field (BETA).
2. Set the Formula
Click on the field and go to the General tab:
- Add a label (e.g., “Total Weight”)
- Click Add Field to choose the number fields you want to use
- Type your formula, like: (Field1 + Field2) / 2
- You can also:
- Set how many decimal places to show
- Add a prefix ($, %, etc.)
- Customize the error message
3. Add Logic Based on the Result
Under the Logic tab, set rules that react to the result of the formula.
For example:
- If result > 100, mark it red
- If result is in between 10 and 20, give it 1 point
- If result is not in range, show a warning
Supported conditions:
- less than / greater than
- in between / not in between
- equal to / not equal to
Things to Know
- Only works with Number fields as inputs
- Great for calculations, validation, and partial scoring
- Does not calculate the full inspection score—just one part