Hello Community,
I need to have an address table that deals with some people having different street and mail addresses and some having only a street address. How can I structure the table to allow for both while being able to filter for a list for mailings? Any thoughts would be appreciated.
Thanks, Scott
Best answer by TheTimeSavingCo
Do you think we could use a formula field to compile the fields like so?
IF(
{Mailing Address},
{Mailing Address},
{Street Address}
)
+31Do you think we could use a formula field to compile the fields like so?
IF(
{Mailing Address},
{Mailing Address},
{Street Address}
)Duh! I'm embarrassed that I did not think of that. Yikes! A mind is a terrible thing to lose. Thank you! Scott
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.