Upcoming database upgrades. to improve our reliability at 03:30 UTC on Feb. 25 / 7:30pm PT on Feb. 24. Some users may briefly experience slow load times or error messages. Learn more here
Dec 06, 2021 02:18 PM
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!
Dec 06, 2021 07:31 PM
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.