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.
Formula on the canvas:
The formula result will return
“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.
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.