function readOnly(count){ }
Sign Up ›
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
Learn More

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, ","  )