Start a conversation

General calculation templates

  • Calculating with checkbox fields

    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...

  • Calculate with grid fields

    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...

  • Validation or dependency on an empty field

    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 ...

  • Calculate the score from several variables

    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...

  • Check if a number contains X number of digits or decimal places

    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 ...

  • Using the record ID, institute or country in a calculation

    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...

  • Calculate the average of several non-required variables

    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...

  • Check if a report was added

    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...

  • Check if the inclusion criteria are met

    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})...

  • Check if a text field contains any numbers

    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...