Support

Need assistance using edc2go? We are here to help

Validation rules: numeric range

"Numeric range" is a validation rule that can be set for the single line field element.
With this validation rule you can:
  • define a field as numeric (allowing only numeric characters: 0-9) (see this article)
  • specify a minimum and/or maximum value for the applicable field (see example A)
  • specify a minimum and/or maximum value based on a linked question (see example B)

Front end

If you enter a numeric value that is outside the specified range, edc2go will display a message upon data entry:

A. for a value outside a specified range:
B. for a value outside a specified range with the range defined by (a) linked question(s)

at this point, you can either:
  • Save the form with an open query.
  • Cancel the save action and go back to the form to correct the value.

Design: numeric range

  • Make sure that your CRF has status 'Design'.
  • Go to your design area via My Studies --> CRF.
  • Go to the applicable visit and form and click the '+ Add validation rule' button on the right hand side of the applicable question:
A validation rules window will open.On the left hand side of the window is the list of all available validation rules of that particular element type:Each element type has its own set of validation rules. To see an overview of possible validation rules per element type, check out this article.

A. Specific Value

  1. Check the box in front of the 'Numeric range' validation rule.
  2. Enter the applicable numeric value for a specific minimum (MIN field) and/or maximum (MAX field).
  3. The query text is present by default as:"Only numbers between min [value min] and max [value max] are allowed". You can update this text as applicable for your question.
  4. Click the Save button.
  5. the '+Add validation rule' button is now displayed as '  üNumeric range' but the button is still functional. Click this button to edit the validation rule(s) for this question.
[value min] is the value as specified in the MIN field
[value max] is the value as specified in the MAX field

B. range defined by (a) linked question(s)


  1. Check the box in front of the 'Numeric range' validation rule.
  2. Click the button in front of 'Linked question' for either the minimum (MIN field) and/or maximum (MAX field) and click the applicable 'Select' button.
  3. The 'Linked question' window will open in which the applicable visit, form and question must be specified via drop down lists that contain your CRF structure.
  4. Within the dropdown lists, there is a visual distinction between visits, forms and questions that can be selected (normal text) and those that can't (italic text). Note that the only elements that can be selected are single line fields that are defined as numeric fields.
  5. Select the linked question that you wish to set as minimum or maximum range for the question. The 'Select' button has now turned into a green colored 'Linked' button:
  6. The query text for this example (only MAX defined) is present by default as:"Only numbers lower than or equal to [value max] are allowed".
  7. It is possible to customize this text to your own preference.
  8. You can use labels [value:max]/[value:min] and/or [text:max]/[text:min] to add the value or question text of the linked question.
  9. [text max] displays the question text of the linked maximum range question
    [text min] displays the question text of the linked minimum range question
  10. Click the 'Save' button.
  11. the '+Add validation rule' button is now displayed as üNumeric range' but the button is still functional. Click this button to edit the validation rule(s) for this question.
  12. The linked question is now also visible in the parent form. It has an orange colored 'Linked question' label.

Feedback and Knowledge Base