Calculation field, test value

Hello Geert,

Together with your additional information, I think I can provide you with the math.



With the above transformations, the factual connection has become more or less clear.
And in my opinion, it is correct so far.
The formal calculation based on the underlying values ​​INO, CNO, and DNO is therefore as follows:
0 == (CNO) - (INO-round((INO/DNO)-0.5)*DNO)

Question 1:
Do you agree with the calculations and the illustration, and what do you think about them?

A request in the form of Question 2:
Could you please evaluate how widespread this control method actually is (institutions actually using it)?

Re: Asian hornet.

You are performing a really important and great work.
The Asian hornet 'vespa velutina' has also spread to Germany.
In France, attempts are being made to combat the Asian hornet, among other things, through large-scale trapping operations using baited bottles.
Such a practice would not be permitted in Germany, as native and endangered insects might also die in the bottles.

Best regards, Ingmar Vack

Hello Ingmar,
I don't fully understand the 'pseudocode', I suppose it is some kind of formal language? I'm fluent in Pascal, VHDL, C++ and Assembler....
I'll have a look at the formal calculation, providing the bees stay calm tomorrow...
As for the Asian hornets, we developed hornet traps that cost 5€, based on a commercial item. We modify them to calibrate the inlet to 8.5mm, provide 7mm escapes for 'other' insects and avoid a 'pool' inside the trap wherein insects would drown.
On the side, I'm also working on a 'smart' trap where a camera with AI identifies an Asian hornet and then kills it by firing a 5W laser beam, all powered by a solar panel and some batteries. No kidding.... I'm a retired engineer but I work harder than before...

Hello Geert,

It's not pseudocode.
It's simple mathematics.
Mathematics that I regularly used as a student and employed physicist to clarify and understand things.

The calculation:
- clarifies what the individual parts of your original formula mean,
- converts your original formula step by step and in a comprehensible manner into the required representation using the basic quantities INO, CNO, and DNO,
- clarifies the prerequisites for implementation in Visforms, at least for me,
- clarifies possible configuration settings in a Visforms implementation, at least for me.

All that remains is the question as a request to you.

A request in the form of Question 2:
Could you please evaluate how widespread this control method actually is (institutions actually using it)?

Re: provide 7mm escapes for 'other' insects and avoid a 'pool' inside the trap wherein insects would drown.
That's really great!

Re: Working on a 'smart' trap.
As a physicist and a nature lover, I completely support you.
I think this is a compelling approach with
- great innovation potential,
- widespread acceptance potential.

Best regards, Ingmar

Hi Ingmar,
Where it is used? All Belgian bank account numbers are protected this way. I don't know about credit card numbers, there the expiry date seems to be 'hashed' in.
Belgian 'national numbers' are protected in the same way.
The ISO/IEC_7064 standard defines the MOD-97-10 algorithm that is used.
See here how it is used :  en.wikipedia.org/wiki/International_Bank_Account_Number
Cheers,
Geert

Hello Geert,

Thank you for your information and the link.
We will implement the new field type.

I've created a development issue in the wishlist:
Issue [VF-1400] Forum: New Field Type: Protected number

When we release the new feature, you will be explicitly informed about the release in this topic.
Thanks again for your suggestion!

Cheers, Ingmar

Hi Ingmar,
Nice to hear the feature will be implemented. My primary problem was to block the form from being submitted if the protected number does not check. I suppose this will be part of the implementation...
Cheers,
Geert