Is an editable Bi-directional relationship possible without Automation?

8

@Al_Chen_Coda By accident I discovered that the Detail View has an unintended side-effect in that it does give you the functionality that you want: Being able to adhocly assign to columns that are driven by a formula.

This caught me completely by surprise, as it’s not really supported through any expected means.

E.g.: Dynamically add Subtasks from the perspective of the Task

In the below embed, I can open up the Detail View of a Task, and create new rows in the “Displayed as Table” Children Formula column, which is driven by a formula. It properly creates the rows in the Subtasks table and assigns them to the parent.

This specifically only works for the Text column. Getting the lookup column to display as a Table only works sometimes, and when it does, you can’t add children. (see Children Lookup)

  • In the below table, select the A row in Tasks-2 and expand into the detail view.
  • See that you can’t add rows to Children Lookup
  • See that you can add rows to Children Formula
1 Like