How to write Validation Rules?

Created by Vishal Arya, Modified on Wed, 26 Jul, 2023 at 3:10 PM by Vishal Arya

You can validate using the excel function.

Pattern

Left_side==Right_side



Added validation on labels


Important:-

  1. The label name should be inside ' not " i.e 'Total Due' not "Total Due".

  2. Currently, the error message is only re-calculated if you visit the label. E.g on the above video when we add 0.13 to total tax, Total Due was till showing an error icon but once you move to total due and click the tab, an error icon is removed as validation matches. We are working on making all fields update in real-time, i.e as soon as any fields are updated all field effected by that change is recalculated and error message are added or removed. Should be live in 2 weeks as this required major change in the codebase.

  3. If you need to use greater or less invalidation, please use >== and <==. For equal, you can use ==. The documentation will be ready next week.



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