Is an editable Bi-directional relationship possible without Automation?

4

Yes, I previously read the post and it does not solve the issue.
The issue is that any column driven by a formula (which this requires) is uneditable.
So any view which normally would allow you to easily change things (like drag & drop a card) don’t work. See the last table in the example in my opening post.

To be clear, to have a relationship that is auto-updated on both sides, only two options are available as far as I know:

(The examples use a Children column in table Task, and a Parent column in table Subtasks)

  • Solution 1: Lookup Column & Formula (see example in first post)
    • Create Lookup Column in Task, name it Children, point it at Subtasks.
    • Create a Lookup Column in Subtasks, name it Parent, point it at Tasks.
      • Formula: Lookup(Tasks, Children, thisRow)
  • Solution 2: Automation
    • Create the same lookup columns in Task & Subtasks.
    • Create Automation that listens for changes on these columns. These automations are relatively complex (need to detect removes, adds).

The problem I am describing is that for Solution 1, the Subtasks are now un-editable as they are driven by a formula (to keep the values in sync).

Solution 2 is untenable for a lot of different reasons: they are error prone, slow (performance tanks) and need to be setup for each relationship while being very complex.

1 Like