Explore

EU VAT Check Pack

A Coda pack to validate VAT numbers of countries of the European Union.

When dealing with companies in the European Union, it might be necessary to validate their VAT numbers. The European Commision offers sevices to validate those numbers. With EU VAT Check pack, you can directly access the offical validation within your Coda doc.

The validateVAT formula

You can use the validateVat() formula everywhere in your doc.

Example 1

Formula on the canvas:

⁠

valid

⁠

Bildschirmfoto 2022-03-09 um 15.47.10.png

⁠

The formula result will return

“Valid”

“Not valid” or an

Error Message like “Invalid Country Code”

The formula result is an object, that returns further information about the business, but also a boolean “true/false” if required.

To access the details, give the formula name and use the dot operator.

Example 2

Named Formula:

⁠

valid

⁠

Boolean Result:

⁠

true

⁠

Business Detail:

⁠

Siegfried-Marcus-Straße 24 AT-5020 Salzburg

⁠

The validateVat column

If you have a list of business, it might be useful to take advantage of the validateVat column. The column automatically validates every row and provides addtional columns with further business details or a boolean result.