All possible validations / automated queries

Modified on Thu, 17 Oct, 2024 at 3:22 PM

Learn which validations and/or automated queries you can set at input form level.


The validations below can be combined as AND or OR connections. A combination of AND/OR is also possible here. For example, condition 1 AND condition 2 or condition 3.


Display the validation message/automated query (text can be customised) if...
Field 1 in any formConditionIndividual Entry
AlternativeField 2 in any form
Text/Numberis emptyN/AN/AN/A
Text/Number
is not emptyN/AN/AN/A
Text/Number
is equal to
individual entryORText/Number 2
Text/Number
is not equal toindividual entryORText/Number 2
Number
is bigger thanindividual entryORNumber 2
Number
is bigger than or equal toindividual entry
ORNumber 2
Number
is smaller thanindividual entry
ORNumber 2
Number
is smaller than or equal toindividual entry
ORNumber 2
Dateis emptyN/AN/AN/A
Date
is not empty
N/AN/AN/A
Date
is equal toindividual entryORDate 2
Date
is not equal toindividual entry
ORDate 2
Date
is afterexact dateORDate 2
Date
is after or exact dateexact date
ORDate 2
Date
is beforeexact date
ORDate 2
Date
is before or exact dateexact date
ORDate 2
Date
is less than x days before/afterToday/Tomorrow/Yesterday/Exact date
ORDate 2
Date
is less than or equal to x days before/afterToday/Tomorrow/Yesterday/Exact date
ORDate 2
Date
is more than x days before/afterToday/Tomorrow/Yesterday/Exact date
ORDate 2
Date
is more than or equal to x days before/after
Today/Tomorrow/Yesterday/Exact date
ORDate 2
Single Choice / Multiple Choice / Dropdown
is emptyN/AN/AN/A
Single Choice / Multiple Choice / Dropdown
is not emptyN/AN/AN/A
Single Choice / Multiple Choice / Dropdown
is equal toAnswer Option (Label x)N/A
N/A
Single Choice / Multiple Choice / Dropdown
is not equal toAnwer Option (Label x)N/A
N/A




⭐ Please note that you can also apply all of the above validations and automated queries to the tables. You can also compare fields in the table with fields outside it (whether on the same form or another).


Read the following article if you want to learn where to find the functions of validations and automated queries in the setup process: 




✉️ Still have questions? Feel free to contact your Customer Success Manager or email us at support@climedo.de.




Was this article helpful?

That’s Great!

Thank you for your feedback

Sorry! We couldn't be helpful

Thank you for your feedback

Let us know how can we improve this article!

Select at least one of the reasons
CAPTCHA verification is required.

Feedback sent

We appreciate your effort and will try to fix the article