Hello! I am trying to build an interface that would allow our team to plan out large projects that require multiple tasks, all in one form. For example, I want to input a Project 1, add a description, input a deadline, and add a priority status. This should feed into a Projects table and I assume have a field that links to the task records.
In that same form, I want the ability to add smaller tasks that are part of the larger project. Specifically, I want to be able to add tasks, a description or notes, a deadline, and most importantly an assignee to that specific task only (not the project). This should feed into a Tasks table with each task as its own record.
One form would be best versus having to create a project on its own and create task records separately. Is there any way to do this? Is this even possible in Airtable?