Skip to main content
Solved

For subtasks, unlink fields but preserve record of link

  • October 13, 2020
  • 4 replies
  • 51 views

Forum|alt.badge.img+12

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!

Best answer by Kamille_Parks11

See this solution:

4 replies

Kamille_Parks11
Forum|alt.badge.img+27

See this solution:


Forum|alt.badge.img+12
  • Author
  • Known Participant
  • October 13, 2020

See this solution:


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


kuovonne
Forum|alt.badge.img+29
  • Brainy
  • October 14, 2020

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_Parks11
Forum|alt.badge.img+27

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.


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.