+ Start a Discussion
Justin DavisJustin Davis 

Validation Rules - Preventing "commas" from use in Address fields

My organization has a bad habit of adding extra commas in the address fields, where Salesforce already provides them. This screws up importing into mapping programs and other exported lists. How can I prevent users from adding commas?


Justin Davis

You'll want to implement a validation rule that triggers if a comma is entered into the field:


Contains( Your_Address_field1, ","  )