For subtasks, unlink fields but preserve record of link

[Darin_Bellisari]

We use linked records to create sub-tasks (the tasks are in one table, sub-tasks are in another table where the entries link to a task)

However, when you look at all the subtasks for a given task, you cannot filter out “completed” subtasks. As a result, it crowds the view. One solution is to unlink the subtask once it’s completed, but then you can never go back and figure out what task that subtask belonged to

Is there any field we can create in the Subtask table that will capture the Task it is linked to, and then preserve that information even when it’s unlinked? Thank you!

[Kamille_Parks · Accepted solution]

See this solution:

Noobie question: I need help from airtable experts, Currently I'm not able to followup on my leads p... Views

Try using two Link Fields: one for active tasks, one for completed tasks. You can use an automation on your Tasks table, once a task has been marked complete, to move the value of the {Projects (Active)} link field to the {Projects (Archive)} link field. In your Projects table you could hide the {Tasks (Archived)} field from view so you only see the {Tasks (Active)} field, which should now only display clickable titles of the tasks which are active.

[Darin_Bellisari]

That is brilliant! Thanks Kamille, let me try it!

[kuovonne]

Darin_Bellisario:

you cannot filter out “completed” subtasks.

You should be able to filter out completed subtasks by filtering the view in the subtasks table.

If you are using a lookup or rollup to see the sub tasks, you can use a conditional lookup/rollup to filter out completed subtasks.

[Kamille_Parks]

I believe he means within the Link field so that he can click on the task to expand the record, as Link fields will show all records linked and don’t have the conditional visibility options of Lookup/Rollup/Count fields.