Share
Explore

icon picker
EU VAT Check Pack

A Coda pack to validate VAT numbers of countries of the European Union.
DS
Daniel Stieber
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.

Example 3


Clients
0
Client
VAT
VAT Check
Valid
Name
Address
Country Code
1
BMW Austria
ATU37035203
valid
BMW Austria Gesellschaft m.b.H.
Siegfried-Marcus-Straße 24 AT-5020 Salzburg
AT
2
Audi Germany
DE811115368
valid
---
---
DE
3
Mercedes France
FR75853252179
valid
STE MERCEDES-BENZ AG
MERCEDESSTRASSE 120 99109 70372 STUTTGART
FR
4
Smart Germany
12345678
Invalid country code
​
not valid
not valid
5
Smart Germany
DE12345678
not valid
not valid
not valid
not valid
There are no rows in this table
⁠


The validateVAT formula
Example 1
Example 2
The validateVat column
Example 3
Clients
Want to print your doc?
This is not the way.
Try clicking the ⋯ next to your doc name or using a keyboard shortcut (
CtrlP
) instead.