cancel
Showing results for 
Search instead for 
Did you mean: 

How can I replicate FieldCopyUnique on Other Address (where individual fields may be blank)

michael-wtds
Frequent Contributor

I want to use FieldCopyUnique to save a different Mailing Address to Other Address.  So, it looks like I need to define each field individually (Other Street, Other City, Other State, Other Country), but I need to make sure I'm keeping the Other Address populated with a complete address either the existing Other Address, or the Mailing Address.

So, would I need to use scoring where I only update if all the Other Address fields are not populated to make sure I'm not only updating the non-blank fields, essentially leaving the other address fields as is if there's a value?

And if FieldCopyUnique behaves like an update if empty, what what if both records have an Other Address fields, except on is missing the Country? For example Country is commonly blank for my US addresses. However, foreign countries are typically filled.  So, how do I avoid populating the blank country field on the address that is retained?

1 ACCEPTED SOLUTION

Pugs_Validity
Validity Team Member
Validity Team Member

@michael-wtds - If I am understanding your question correctly, there are a couple items at play here, but I would first reccomend populating that country field for the US addresses using Modify so that you can avoid that potential pitfall. The being said, FieldCopyUnique Overwrite should be your friend here. This will take the unique value and overwrite the existing value in the mapped location. Whereas FieldCopyUnique will respect that update if empty logic for the field you are mapping to and leave it alone if it is currently populated. Does that answer your question?

Pugs_Validity_0-1730492445612.png

 

View solution in original post

3 REPLIES 3

Pugs_Validity
Validity Team Member
Validity Team Member

@michael-wtds - If I am understanding your question correctly, there are a couple items at play here, but I would first reccomend populating that country field for the US addresses using Modify so that you can avoid that potential pitfall. The being said, FieldCopyUnique Overwrite should be your friend here. This will take the unique value and overwrite the existing value in the mapped location. Whereas FieldCopyUnique will respect that update if empty logic for the field you are mapping to and leave it alone if it is currently populated. Does that answer your question?

Pugs_Validity_0-1730492445612.png

 

@Pugs_Validity Thank you for the guideance on this, and can you point me to the help documentation on Field Copy Unique Overwrite, as I didn't see this in the field rules page I was using.

https://knowledge.validity.com/s/articles/Field-Rules?language=en_US

For now it does look like Field Copy Unique, along with scoring is going to get me there.   In my case if none of the Other Address fields are populated, and if Mailing Address is populated, then the FieldCopyUnique will update each selected field.   This just keeps it very black and white, that if any Other Address field is populated, don't bother with an update.

To simplify the scoring, I created 2 custom fields in Salesforce that are true if any address field is populated (Street, City, State, Zip, Country), which I with the following formula:

  1. Mailing Address Populated
    NOT(ISBLANK(MailingAddress))

  2. Other Address Populated
    NOT(ISBLANK(OtherAddress))

Then in the Field Scoring, I checked to see if Mailing Address Populated is True, and Other Address Populated is False.

Eventually if I find that I have some lower quality Other Addresses that are very incomplete, I'll likely need to revisit this.  But for now I have mostly blank Other Addresses in my data, and this seems to be the solution I need.

Thanks again for your feedback!

You have the right article, we likely need to add some additional clarification for that specificity. Additional clarity can be found in the 5.37.1 Release Notes. That's a creative workaround, I think your thought process seems sound as well. Let us know if anything else comes up!