Save the date! Join us on October 16 for our Product Ops launch event. Register here.
Jun 02, 2023 05:00 AM
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
Solved! Go to Solution.
Jun 02, 2023 05:31 AM
Do you think we could use a formula field to compile the fields like so?
IF(
{Mailing Address},
{Mailing Address},
{Street Address}
)
Jun 02, 2023 05:31 AM
Do you think we could use a formula field to compile the fields like so?
IF(
{Mailing Address},
{Mailing Address},
{Street Address}
)
Jun 02, 2023 07:22 PM
Duh! I'm embarrassed that I did not think of that. Yikes! A mind is a terrible thing to lose. Thank you! Scott