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/
Why trigger and not workflow? I think answers are A and C
upvoted 3 times
...
Log in to ExamTopics
Sign in:
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
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
8 months, 1 week agothisistestuser
8 months, 1 week agothisistestuser
8 months, 1 week agoKithulBoy
1 year, 2 months agoKLUNA
1 year, 7 months agoRoseMoe
11 months, 3 weeks agotMana
1 year, 7 months agotMana
1 year, 7 months agoSC22MarkTopics
1 year, 11 months agorestigian
2 years ago