Can I check a IBAN account number within a model?

Tool Set Data Modeler
1

We have a form that contains a IBAN code. We would like to check the validity of the IBAN code right when the user enters it (i.e. within the form).
The IBAN code has a well defined structure and must adhere to some rules. See here: International Bank Account Number - Wikipedia

Does anyone know how we can check this within the form?

2

Maybe I don’t fully understand the problem, but

  1. Use a typescript iban validation library, at first sight this one looks good for example: GitHub - Simplify/ibantools: IBANTools is TypeScript/JavaScript library for validation, creation and extraction of IBAN, BBAN and BIC/SWIFT numbers.
  2. Use a CustomCondition to add the validation like discussed here: How to add CustomConditions
3

I did not check in detail but you could also try a regular expression on a string field to check the format and use rules for additional validation (e.g. checksum).

There are plenty of regEx suggestions for IBAN in the internet, however, these regEx are complex and long but A12/Data Modeler accepts regExs with up to 100 characters only. This makes it tricky to find a good one which also fits in the Data Modeler.

5

ERU has this functionality built-in as far as I remember and maybe even the A12 Validation Kernel.
<INTERNAL_LINK> is supposed to provide this kind of functionality for the Data Modeler in the future.

6

Update:
The Pattern field in the Document Model Editor now accepts up to 1000 characters. I checked the following versions of the Simple Model Editor (6.7.1, 7.1.4 and 8.0.0 from the 2021.06, 2022.02 and 2022.06 installers)

In addition you can use the PatternViolated operator in a Validation Rule. This can accept even more characters. Just enter the field reference, PatternViolated and you regEx as shown in the picture. This example has 2392 characters.

PatternViolated1
PatternViolated1645×719 49.1 KB