Hi everyone,
I'm looking for guidance on implementing a field-level format validation in Creatio and wanted to check if there's a recommended no-code or low-code approach before going down the custom development route.
The requirement is as follows:
- We have a VAT Number text field on the Account (or Contact) page.
- For domestic customers, the value must follow the local VAT number format.
- For foreign (EU) customers, the value must follow the EU VAT number format: 2 letters followed by at least 6 digits (e.g., XX12345678).
- The correct format to validate against should depend on the value of the Country field on the same record.
What I'd like to achieve:
- When a user enters a VAT number that doesn't match the expected format for the selected country, the system should show a validation error and prevent saving.
My questions:
1. Is there a way to implement pattern/regex-based validation like this using Business Rules or Process Designer, without writing custom code?
2. If not, what would be the recommended approach, client-side field validation (JS), server-side entity validation, or a business process with a Formula element?
3. Has anyone implemented something similar (country-dependent format validation) and would be willing to share their approach?
Any guidance, examples, or links to relevant documentation would be greatly appreciated.
Thanks in advance!
Like