The administrator at Universal Containers wants to improve data quality by ensuring that all accounts have a Billing State/Province based upon the Billing Postal Code for that account. Which two solutions can meet the requirement? (Choose two.)
A.
Use a trigger that populates Billing State/Province based on a custom object that maps postal codes to states/provinces
B.
Use a validation rule to do a VLOOKUP of the Billing Postal Code to a custom object that maps postal codes to states/provinces
C.
Use a workflow that populates Billing State/Province based on a custom object that maps postal codes to states/provinces
D.
Use a validation rule to do an HLOOKUP of the Billing Postal Code to a custom object that maps postal codes to states/provinces
B & C are the right answers. But, since we are now in 2023, I believe Flow would be the right answer. Also, check out this video on using VLOOKUP in validation rules: https://www.youtube.com/watch?v=s6qxZ96MZKQ
B. Use a validation rule to do a VLOOKUP of the Billing Postal Code to a custom object that maps postal codes to states/provinces.
C. Use a workflow that populates Billing State/Province based on a custom object that maps postal codes to states/provinces.
The following are the explanations for the above two options:
B. Use a validation rule to do a VLOOKUP of the Billing Postal Code to a custom object that maps postal codes to states/provinces. This solution will work by creating a custom object that maps the postal codes to their respective state/province. The validation rule will then reference this custom object to populate the Billing State/Province field based on the Billing Postal Code.
C. Use a workflow that populates Billing State/Province based on a custom object that maps postal codes to states/provinces. This solution works similarly to the validation rule approach, but uses a workflow to automate the process.
A flow would indeed be better (as a reminder workflow will be deactivated Winter '23)
https://provenworks.com/populate-us-state-from-zip-code-using-a-salesforce-flow/
A voting comment increases the vote count for the chosen answer by one.
Upvoting a comment with a selected answer will also increase the vote count towards that answer by one.
So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.
thisistestuser
7 months, 2 weeks agothisistestuser
7 months, 2 weeks agothisistestuser
7 months, 2 weeks agoKithulBoy
1 year, 1 month agoKLUNA
1 year, 6 months agoRoseMoe
11 months agotMana
1 year, 6 months agotMana
1 year, 6 months agoSC22MarkTopics
1 year, 10 months agorestigian
1 year, 11 months ago