Check value in calculation field

Hello,
I'm designing a form to track samples of bees from different hives. The idea is that the beekeeper takes a sample of 10 bees and puts them in a canister that has a sample number. The beekeeper has to enter this number in the form relative to the hive from which the sample is taken.
To avoid errors I want to include a check: the 4 first digits of the number are the sample number, the 2 next digits represent the remainder of the sample number divided by 97. ex. 70 being the remainder of 1234/97, 123470 is a valid number 123407 is not. (the same system is used in bank account numbers, at least in Belgium).
In a calculation field I can extract the entered check number and the calculated check number but I have no way to compare them....
Should I look into regular expressions? I hope not...
Kind regards,
Geert

Hello Geert,

Calculation fields can do a lot and are sufficient in many places.
Due to the highest possible security, the calculation becomes independent of each other
- a first time locally in the browser in JavaScript and
- done a second time in PHP in the backend.

However, this results in an intersection of the available functions and actions that you can use.
Because the code must be executable for JavaScript and PHP at the same time.

In your case, it is better if you implement your individual solution with JavaScript and the 'Visforms web assets'.
Here you have virtually all the options you need.
You can react (a field value changes), calculate and act as you wish (influence other fields).

You simply add your JavaScript code to the affected Visforms view (form, data, ...) using the Visforms 'Frontend Webassets'.
The procedure is described in the documentation.

Frontend web assets:
docs.joomla-5.visforms.vi-solutions.de/e...-frontend-webassets/
All settings are made in the form:
docs.joomla-5.visforms.vi-solutions.de/e...are-made-in-the-form
Examples of solving requirements with the frontend web assets:
docs.joomla-5.visforms.vi-solutions.de/e...-webassets/examples/

Kind regards, Ingmar