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?

0 REPLIES 0