For records that require accurate readings, for example Equipment Maintenance Logs, Process Monitoring Sheets, Environmental Monitoring Forms, Calibration Records, Quality Control Checklists, etc., it is necessary to display a warning when a reading is out of range.
To start, navigate your cursor to the left tab and choose whichever table suits your form. Your table should closely look like this (for example a Calibration Record).
Date | Calibration Standard | Temperature Reading | Comments | Warning |
|
| C+ |
| (Formula field) - F+ |
For example,
To display a warning when the initial and final readings are beyond 22 degrees, a warning is displayed in the F column. And if it is below 20 degrees, another warning is also displayed.
Use the formula,
=IFS(C1>22, "Warning, with deviation. Recalibrate.", C1<20, "Too low temperature. Recalibrate.")
Note: When you fill out the form and add more logs, the formula is automatically populated.
With no log, the warning cell may display "Too low temperature. Recalibrate."