Linking parent and child tasks within the same table (using automations)

[cruizm14]

Hi, 

I have a table with tasks and would like to also manage subtasks in the same table. Currently, I have a linked field called "child". Using this field, I link to other tasks within the same table. So, a parent task record might show multiple linked records in the "child" field. I also have a "parent" field that allows linking to a single other record within the same table.

I'm looking for a solution that works as follows:

Trigger: When the field "child" of a record is updated

Action: Update "parent" field of the child record (s)*

I created an automation that works for parent records with a single linked record in the "child" field (I did this by creating a formula field that converts the linked record in the "child" field to text). But whenever the "child" field has more than one record, the automation breaks down. Can anyone help?

Thanks in advance! 

[TheTimeSavingCo]

What are you updating in the parent record?  Could you share screenshots of the table with relevant fields as well as screenshots of your automation as it is now?

[Karlstens]

Same-table parent-child linked field options are absolutely needed. Automations and scripts just don't cut it for what I consider would be such a core feature.

[v1_oh_n0]

On this subject I am trying to create an automation to create the Child Record link in the Parent Record. The problem I am running into is that there may be multiple child records for a single parent record and the automation is unable to take more than one link to another record in the child record field. I would like this to work so that it maintains any records already in this field and to add the record which triggered the automation.