Show your excel formula
Take this value (which is size 11)
Insert in the yellow block, use the red block
Text → your Text box
Start ->number
Lenght ->1
above to take each digit and multiply by the respective multiplier…
From 1
To 11
By 1
of course I attach it there
1-
2-
3-
4-
5-
Multiply and accumulate inside yellow block
set total = total + (digit x multiplier)
Thank you very much for your kindness and help, orient me much better now, I appreciate.
How do you optain first 6 ?
It is part of the number to be entered
It is usually the last digit of your number that was generated by the algorithm.
It’s digit verifier
It is part of each customer’s number (in This case , digit 11)
So with the first 10 digits of the example, the last will always be 6. If you enter another number, it will not be valid.
#off-topic Now it’s time to go to court
So actually you want to check true or false, valid or not
Modified procedure to check if contains letters or if number doesn’t have 11 digits (I used regex extension by @Kevinkun )
Excuse me for the late answer, I had no connection, the blocks that it shows me are based on the example excel that I published? because I would appreciate it very much
Yes since I believe seeing your excel example that you want to check whether an Argentinian VAT number is valid or not.
correct, where the user can put any cuit with only 11 digits and the excel calculation what verifies is that what input is valid or not.
.Yes , taking the multiplier number (5432765432) and putting it on Google , we found this information 🤷
They are “routines” or “algorithms” to generate a number with your own verification digit (it exists worldwide - credit cards, bank accounts, social security number)
I unmarked my solution: you have the aia and the blocks.
A suggestion: as the algorithm is based on calculations only, use a java example and use the tool to create an extension. Is not difficult.
https://www.google.com/search?client=firefox-b-d&q=vat+number+validate+algorithm+java
If this is not correct, just look on Google…
@Still-learning link provided is for EU countries only. Also this was just to show that many things can be done without extensions or use of an api.
I really appreciate your time and response and kindness on my topic, you helped me a lot to orient myself and to continue. I thank you again.
This topic was automatically closed 30 days after the last reply. New replies are no longer allowed.