Data checks

Coming soon: check VAT numbers on VIES, IBANs, Italian tax codes, phones and emails, write phones in the international format, find duplicates on the board.

Coming soon: with the next version of General Caster. This page shows how it will work.

Forms, emails and imports fill boards with VAT numbers with a typo, IBANs missing a digit, phones without a country code, the same customer twice. monday checks none of it. These functions do, and their result goes into a Status or a column: monday’s own automations then notify the right person or move the item to a group.

VAT numbers

Function Gives
VAT.CHECK(number, [country]) TRUE when the number is valid and registered for trade between EU countries
VAT.NAME(number, [country]) The registered company name
VAT.ADDRESS(number, [country]) The registered address, on one line

They ask VIES, the European Commission’s service, for the 27 EU countries and Northern Ireland. Write the number with its country in front (IT01234567890, DE123456789; Greece is EL) or give the country as second argument: VAT.CHECK({item's VAT number}, "IT"). Spaces and dots don’t matter. Some countries (Germany, for example) don’t give names and addresses: VAT.NAME is then empty even for a valid number.

IF(VAT.CHECK({item's VAT number}), "Valid", "To check")          → into a Status column
VAT.NAME({item's VAT number})                                    → the company name, into a Text column

Each number checked costs 1 more credit, in every plan. The same number asked again within 30 days isn’t sent again. When a country’s service doesn’t answer (it happens), monday tries the automation again later.

IBANs and Italian tax codes

Function Gives Example
IBAN.CHECK(iban) TRUE when the IBAN has the right length for its country and right check digits IBAN.CHECK("IT60 X054 2811 1010 0000 0123 456") → TRUE
IBAN.FORMAT(iban) The IBAN in groups of four, in capitals IBAN.FORMAT("it60x0542811101000000123456") → IT60 X054 2811 1010 0000 0123 456
TAX_CODE.CHECK(code) TRUE for a valid codice fiscale, of a person (16 characters) or of a company (11 digits) TAX_CODE.CHECK("RSSMRA85T10A562S") → TRUE

They check how the code is written (a typo, a missing character), not that the account or the person exists. No extra credits.

Phone numbers

Function Gives Example
PHONE.INTERNATIONAL(phone, [country]) The number in the international format PHONE.INTERNATIONAL("02 1234 5678", "IT") → +39 02 1234 5678
PHONE.CHECK(phone, [country]) TRUE for a valid number PHONE.CHECK("333 123 4567", "IT") → TRUE
PHONE.COUNTRY(phone, [country]) The country, as a two-letter code PHONE.COUNTRY("+44 20 7946 0958") → GB

A number written without + or 00 is read in the country you give ("IT", "DE"); with +39 or 0039 the country isn’t needed. PHONE.INTERNATIONAL written into a Phone column keeps every number in the same form. No extra credits.

Email addresses

EMAIL.CHECK(email) gives TRUE when the address is written right and its domain receives email: [email protected] (with .con instead of .com) gives FALSE. It doesn’t check that the mailbox itself exists. No extra credits.

Duplicates

MONDAY.BOARD.HAS(column, value) gives TRUE when another item of the same board already has that value in the column, the item itself left out:

IF(MONDAY.BOARD.HAS("Email", {item's Email}), "Duplicate", "New")   → when an item is created, into a Status column

Exact values count, upper and lower case aside; columns by title or ID, as for MONDAY.FIND. 1 more credit per search.

The VAT, email and duplicate checks work on the item of the trigger, not in a block that calculates a whole group or board.

Still stuck?

Check your formula step by step, or ask us: we usually answer within one business day.