Share
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.
Example 3

Clients
0
Search
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


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.