Help

Table design to account for different street and mail address if a mailing list is required

Topic Labels: Base design
Solved
Jump to Solution
647 2
cancel
Showing results for 
Search instead for 
Did you mean: 
Scott_Brasted
7 - App Architect
7 - App Architect

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

1 Solution

Accepted Solutions
TheTimeSavingCo
18 - Pluto
18 - Pluto

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

Screenshot 2023-06-02 at 8.29.52 PM.png

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

Link to base

See Solution in Thread

2 Replies 2
TheTimeSavingCo
18 - Pluto
18 - Pluto

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

Screenshot 2023-06-02 at 8.29.52 PM.png

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

Link to base

Scott_Brasted
7 - App Architect
7 - App Architect

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