This si what I want to do
IF (AND(BillingCountry = "United Kingdom",
AND(NOT(REGEX(VAT_Number__c ,"[A-Z]{2}[0-9]{9}")), NOT(ISBLANK(VAT_Number__c ))))
AND
IF(AND(BillingCountry = "Ireland",
AND(NOT(REGEX(VAT_Number__c ,"[A-Z]{2}[0-9]{7}[A-Z]{1}")), NOT(ISBLANK(VAT_Number__c ))))))
The top validation works without the IF when it is on its own.
1 answer
Hi Olivia,
I would write separate validation rules for each country that way you can show the error message to the users base on the Billing Country.Your Validation rules will be like below
AND(
BillingCountry = "United Kingdom",
NOT(ISBLANK(VAT_Number__c)),
NOT(REGEX(VAT_Number__c ,"[A-Z]{2}[0-9]{9}"))
)
............................................
AND(
BillingCountry = "Ireland",
NOT(ISBLANK(VAT_Number__c)),
NOT(REGEX(VAT_Number__c ,"[A-Z]{2}[0-9]{7}[A-Z]{1}"))
)
