In this tutorial you will learn how to set up validation rules to validate against the data stored
If you are new to ConfiForms, please take a few minutes to read the Basic concepts Guide, or go through the video tutorial on that page.
Often there is a need to setup some checks to ensure the limits on some values.
In the example below we have a requirement to deny registrations if the dataset has already 3 records of the choice B
This validation is possible to automate in ConfiForms by using the "ConfiForms Field Definition Rules" macro and using it's "Action" selected to "Validation Rule (dataset)"
We start with the form, which has only one field of type Dropdown, a registration Control macro to enable new registrations and "ConfiForms Field Definition Rules" macro with rules to check the dataset
The dropdown field looks like this:
has 3 values: A, B and C
And the rules for validation is as follows:
we check for values "B" and count them using built-in variable
Variable has changed from [count] to _count as in Accessing field values and properties
Condition will match when a dataset has 3 records (where field value for field "myddfield" is "B") in it already
When it does the message to use will be shown
Storage format (configuration) for the whole solution:
Of course you can have as many validation rules as you want/need, with different conditions (which span across many fields if necessary)