Start a conversation

General calculation templates

  • Calculate the BMI using height and weight

    You can use this template to calculate the BMI of the patient.  Fields needed: Height of patient in meters, variable name: height Weight of patient in kilograms, variable name: weight Template to use:...

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

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

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

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

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

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

  • Calculate the eGFR with the MDRD formula

    With this formula you can calculate the glomerular filtration rate (GFR) using the MDRD study equation: var Age = getDateDiff('{DOV}','{DOB}','y'); var eGFR= 186 * Math.pow(({Creat}/88.4),-1.154) * Ma...

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