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!
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.
This topic was solved and automatically closed 15 days after the last reply. New replies are no longer allowed.