Validate that the Website extension provided is valid #inSalesforce

on

Validate (field like Website) to ensure its last four characters are valid website extensions


Field Name: Website


Formula:

AND(
RIGHT( WebSite__c, 4) <> '.COM',
RIGHT( WebSite__c, 4) <> '.com',
RIGHT( WebSite__c, 4) <> '.ORG',
RIGHT( WebSite__c, 4) <> '.org',
RIGHT( WebSite__c, 4) <> '.NET',
RIGHT( WebSite__c, 4) <> '.net',
RIGHT( WebSite__c, 6) <> '.CO.UK',
RIGHT( WebSite__c, 6) <> '.co.uk'
)


Error Message: Web Site must have an extension of .com, .org, .net, or .co.uk.


Error Location: Web Site

Comments

Post a Comment