I calculate in excel lead to logic blocks

Show your excel formula

image

Take this value (which is size 11)
Insert in the yellow block​:point_up:, use the red block

image
Text → your Text box
Start ->number
Lenght ->1

above :point_up:to take each digit and multiply by the respective multiplier…

From 1
To 11
By 1

of course I attach it there
1-
image
2-
image
3-
image
4-
image
5-
image

1 Like

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.

1 Like

How do you optain first 6 ?

image

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 :badminton::tennis:

So actually you want to check true or false, valid or not

image

Blocks are draggable to test

Modified procedure to check if contains letters or if number doesn’t have 11 digits (I used regex extension by @Kevinkun )

image

1 Like

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)

1 Like

Try this aia

argentinian_vat.aia (12.1 KB)

I unmarked my solution: you have the aia and the blocks. :point_up: :clap:

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. :+1:
https://www.google.com/search?client=firefox-b-d&q=vat+number+validate+algorithm+java

If this is not correct, just look on Google…

1 Like

Yes extension would be good. Also they can try with some free api also

https://www.isvat.eu/

@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.

1 Like

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.

1 Like

This topic was automatically closed 30 days after the last reply. New replies are no longer allowed.