Welcome to the community, Maxwell! :grinning_face_with_big_eyes:
It does quite literally what it says: it limits record selection—i.e. the ability to manually select records from another table—based on records visible in a specific view of that table. It doesn’t change existing linked records.
What you’re trying to do—dynamically change the collection of linked records (tasks) tied to another single record (your project)—is not currently possible in Airtable. However, with some workarounds, something similar could be achieved.
Here’s a dummy aProjects] table I made, with a single project that links to three tasks from a Tasks] table.
On that OTasks] table, I have a {Done} checkbox field, the reciprocal link field pointing to tProjects], and a formula field named {Name Copy} containing this formula:
IF(NOT(Done), Name)
Without any tasks marked as done, it looks like this:
Back in the Projects] table, I added a Rollup field named {Tasks to Complete}, choosing the {Tasks} link field as the source field, the {Name Copy} field as the field to pull from, and ARRAYCOMPACT(values) as the aggregation formula, which gives me this:
Once I check off the first task, its {Name Copy} field goes blank:
And the record in {Projects} now looks like this:
Feel free to hide {Name Copy} to clean up the look of that table if you wish.
The downside is, of course, that you have two fields with tasks in aProjects]. However, because the {Tasks} field only serves to create the task links, you can shrink that one down much smaller. The info you really want to see—which ones are completed—is in the {Tasks to Complete} rollup.
Welcome to the community, Maxwell! :grinning_face_with_big_eyes:
It does quite literally what it says: it limits record selection—i.e. the ability to manually select records from another table—based on records visible in a specific view of that table. It doesn’t change existing linked records.
What you’re trying to do—dynamically change the collection of linked records (tasks) tied to another single record (your project)—is not currently possible in Airtable. However, with some workarounds, something similar could be achieved.
Here’s a dummy aProjects] table I made, with a single project that links to three tasks from a Tasks] table.
On that OTasks] table, I have a {Done} checkbox field, the reciprocal link field pointing to tProjects], and a formula field named {Name Copy} containing this formula:
IF(NOT(Done), Name)
Without any tasks marked as done, it looks like this:
Back in the Projects] table, I added a Rollup field named {Tasks to Complete}, choosing the {Tasks} link field as the source field, the {Name Copy} field as the field to pull from, and ARRAYCOMPACT(values) as the aggregation formula, which gives me this:
Once I check off the first task, its {Name Copy} field goes blank:
And the record in {Projects} now looks like this:
Feel free to hide {Name Copy} to clean up the look of that table if you wish.
The downside is, of course, that you have two fields with tasks in aProjects]. However, because the {Tasks} field only serves to create the task links, you can shrink that one down much smaller. The info you really want to see—which ones are completed—is in the {Tasks to Complete} rollup.
This is great, thanks! The duplicate field isn’t even that bad since my rollup field will contain things I need to do, and my tasks field will allow me to look back at the OLD tasks that may contain relevant notes. The only thing that would make this a little better would be the ability to click on tasks in either field to blow them up and look at all the details, since currently I can look at my tasks to complete but still need to click in the tasks field see detail.
