I am setting up a project tracker base with multiple projects that utilize the same tasks. I have a Tasks table that links to projects table. I think I need to have a formula field for the Tasks primary field. If so, whats the formula? If not then what? Thank you community!
Would you be able to share this when it’s ready? I’m trying to do something very similar right now
My pleasure! This is what Laurie from Airtable told me and it works like a dream!
You will want to separate the Task table into a Task Type table and a Project Task table. You are basically creating a join table which you can read more about here: Check out the video A-beginners-guide-to-many-to-many-relationships.
That way, for information that stays the same for all tasks (perhaps the Task Lead?) you leave in the Task Type but then you can customize the task that is for a particular project in the Project Task.