Save the date! Join us on October 16 for our Product Ops launch event. Register here.
Nov 02, 2021 03:38 PM
I manage 3 e-newsletters for my non-profit. Ads come from the same group of advertisers. Newsletters monthly, quarterly and a set schedule.
What is the best way to schedule all 3 publications in one base?
For some reason I just can’t wrap my head around the layout.
Lenette
Nov 16, 2021 11:51 AM
I still need help trying to design this base. Currently, tracking via excel spreadsheets is not optimal since I published ads in the wrong newsletter.
Lenette
Nov 16, 2021 12:50 PM
Hey Lenette,
There are probably multiple ways you could do this, but here’s an option.
Create 1 table for Newsletters, 1 for Ads, and 1 for Schedule. Create a linked record field between Newsletters and Ads, and then create a linked record field between Schedule and Newsletters.
Then, add a Lookup field in the Schedule table that looks up the Ads field inside the Newsletter table. Create specific views with filters by date.
You might consider hiring an Airtable expert in the Hire a Consultant channel or view a list of consultants here who can help you with the best way to structure it.
Good luck!