How can I make sure that a custom field only has .com, org or .edu or .net as last 4 characters. I hope its a validation rule
Thanks!!
3 réponses
If you want to make the formula case -insensitive, you could modify Geoff's formula to be this:
CASE(
RIGHT(LOWER(Site__c), 4),
".com", 1,
".net", 1,
".org", 1,
".edu", 1,
0
) <> 1
