Check if a box was checked Checkbox fields get saved as a semi-colon separated string, e.g. 1;4;5. To be able to perform calculations with these values, you have to split the string in separate values...
You can also calculate with grid field values. For example, you can calculate the sum of a row or column in your grid. This of course makes sense if you are using numerical fields, but can sometimes a...
See here how you can allow empty fields in a calculation. If you want to create a validation warning or a dependency when there is no data entered in a field, you can use a calculation field to check ...
You can add values from different fields together using a calculation field. For example, you can use this template to calculate a risk score based on multiple risk factors. In this example we use the...
Using calculation fields, it is possible to check if the number that is entered in a numerical field corresponds to a certain format. For example, you can check if a number contains 3 digits or if it ...
You can use the institute abbreviation, institute name, or the institute country in a calculation in any of the study, report, or survey forms. This is handy if you want to show the institute or count...
Check with calculation To check if a report (e.g. an SAE form) was added, you can check if a required variable name on the report has been defined. You need the following syntax to achieve this: '##al...
Sometimes you want to calculate the average of several variables, but some of them are non-required and can thus be left empty. But you still want to calculate the average from all *answered* variable...
Using calculation fields, it is possible to check if a patient fulfills certain inclusion criteria. Below is an example that checks whether a patient has a certain disease (variable {pat_has_example})...
When using a text field, you can use the following template to check whether the field contains any numbers and display a message of your choice. Create a calculation field in the study form using th...