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
mckinnmdmckinnmd 

How to make Billing Address fields required

Hi everyone,

Not sure if this has already been solved, but my company (in the past) has had issues with making the billing address required. My solution is as follows:
  1. Create a formula field that assigns a value of 1 for each completed address field you want to make required.
    • For example, if you wanted to require BillingCity and Billing State, write this formula:
      • IF (LEN( BillingCity ) = 0, 0,1)+
        IF (LEN( BillingState) = 0, 0,1)
    • This formula would return a value of 2, if those fields were completed.
  2. Create a validation rule that prevents saving a record unless "Billing Address Score" is equal to 2

MaxaMaxa

try a validation rule

something like this one

OR(
   LEN( MailingStreet ) = 0,
   LEN( MailingCity ) = 0,
   LEN( MailingCountry ) = 0
)
mckinnmdmckinnmd
Sorry for the confusion, I wasn't asking the question but rather posting my own solution.

It looks like Maxa's solution alleviates the need to create any additional fields.

Thanks!