Skip to main content

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

Do you think we could use a formula field to compile the fields like so?

IF(
{Mailing Address},
{Mailing Address},
{Street Address}
)

Link to base

Duh! I'm embarrassed that I did not think of that. Yikes! A mind is a terrible thing to lose. Thank you! Scott

Reply


Terms & Conditions