I have a table of projects, and a table of tasks, and I can create new tasks within a project by entering them directly in the column linked to the tasks table.
First of all I’m curious if this is the best way to do things, since technically I’m creating a many-to-many join where I can have tasks that are unassociated, or tasks that are associated with several projects, both of which I have no intention of ever doing; I only want each project to have 0 or more tasks that are strictly associated with that one project.
More importantly though, when I finish a task I created a checkbox field on the task called “complete” which I would like to cause my task to be hidden from the tasks field in the projects table. I had assumed that creating a view of incomplete tasks in the tasks table (which I did, and it works fine), then checking the “Limit record selection to a view” and selecting the incomplete task view, would do exactly what I want. But it doesn’t, and I don’t even understand what it could possible do if not that! So what is limit record selection to a view, and if not what I need, is there a way do do it?
I’ve just started using airtable for this and so I could start my entire project/task list from scratch pretty easily if there is a better way of organizing things!