Help

Save the date! Join us on October 16 for our Product Ops launch event. Register here.

Design of Contacts Database to pull a USPS Mailing List

Topic Labels: Base design
894 0
cancel
Showing results for 
Search instead for 
Did you mean: 
Aubrie_Entwood
4 - Data Explorer
4 - Data Explorer

Hello,
I need help figuring out the best base set-up for my specific conditions. Working backwards, I want to be able to download as a CSV one accurate list of records that will all receive a printed mail piece. The records must contain:

  • address line1
  • address line2
  • city
  • state
  • zip

Addresses will contain one of the following options:

  1. Person info:
  • Person’s First Name
  • Person’s Last Name
  1. Organization info:
  • Organization’s Name
  1. Both #1 and #2

The tables I currently have:
People
People Addresses
Organizations (addresses in this table)

I need a way for the table or view that I download the CSV from to pull the correct mailing address because I have some organizations that do not have a person affiliated with them.

Do I have my tables organized in the best way?
Is there an automation that I need to run to achieve my goals?
Is it a lookup field that I need to use instead of automation?

I have the FREE version of Airtable and it is unlikely I’d be able to use a paid version.

Thanks!

0 Replies 0