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.