Help

Multiple Newsletter Ad Scheduling

Topic Labels: Base design
543 2
cancel
Showing results for 
Search instead for 
Did you mean: 
Lenette_Egan
5 - Automation Enthusiast
5 - Automation Enthusiast

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

2 Replies 2
Lenette_Egan
5 - Automation Enthusiast
5 - Automation Enthusiast

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

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!

______________________________________
Hannah - On2Air.com - Automated Backups for Airtable