Setting up content calendar and related to do lists for my food blog

Topic Labels: Base design
976 1
Showing results for 
Search instead for 
Did you mean: 
4 - Data Explorer
4 - Data Explorer

Hi! I need help with the best way to set up my base. In one table I have a list of blog post titles with related information in multiple fields. For each blog post, there are a set of related to do tasks (that are always the same): rough draft, recipe test, plan shoot, photo shoot, edit photos, write post. I need to be able to view the remaining tasks for each blog post, but also have separate due dates for each task. What would be the best way to set this up? Thanks!

1 Reply 1

Since there are always the same tasks, you may be able to just add 6 date fields (one for each task) and a single select field for “current status”.

Otherwise you could have another table for Tasks where each task would be linked to a Blog Post (so 6 linked records per post). You could use an Automation with a series of Create Record steps to automatically create the 6 linked records whenever a new Blog Post record gets created.