Sign Up ›

Browse by Topic
ShowAll Questionssorted byDate Posted
+ 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?

thanks.

Justin Davis
AdminisaurusRexAdminisaurusRex

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

 

Contains( Your_Address_field1, ","  )