If you want to check whether certain fields are filled in, you can use the template below. In this template, there are 2 fields: Variable name Field label dem_pat_gender Gender dem_pat_yob Year of Bi...
Sometimes you need to convert the units of a given measure to keep a unified format across your study. These conversions are usually inches or feet to centimetres and pounds to kilograms, or vice-vers...
If you want to round numbers to an X number of decimals, you can use the templates below. Change the number after 'toFixed(' to change the number of decimals. To round up to 0 decimals, use: var num =...
With this calculation template, you can check whether a group of fields have been filled in or are empty. If certain fields are not filled in, they will be listed in the calculation. In this example, ...
You can enter data with different measurement units, and standardise all collected data with the same measurement unit with a calculation. For example, let's say that you are collecting the medication...
The instructions described in the article Calculate with grid fields renders the objects in string (plain text). If you want to do mathematical operations with numbers, you will need to convert that ...
Following the basics described in Calculate with grid fields, the current article explains how to calculate with grids when the cells have been defined as date. Once again, the first step is to parse ...
Calculation fields can be used to validate values in the grid field. For example, this template validates the values entered in the first and second columns of the first row. var obj = JSON.parse('{gr...
While the average is the result of performing some mathematical operations, the median is employed more as descriptive of the data set and usually involves no mathematics. The median is thus defined ...
Calculation fields can be used to make other fields dependent on certain values added to the grid field. For example, this template outputs 1 if the data entered into the Row one, Column 1 is 'Yes' (e...