Hello, I am new to Coda so pardon my lack of Coda language as I try to explain this! When I add a linked relation within a table, I am wanting that row to automatically add the opposite relation to the same column of the referenced row.
For example, (see attached screenshot), if I add the vocab term “Hot” to the “Opposite term” column for Cold, I would like for “cold” to automatically show up in the “Opposite term” column for “Hot”. Does anyone have ideas on how to achieve this?
I did figure out that I can make it so that there is one input column and then it will add the opposite to a new column. And then it is possible to use a formula to concatenate the two. It’s not ideal though to have 3 columns and because the results show up as @vocabterm.
I don’t know of a way to have what you are after that just uses direct relations without perhaps making a relationship table that would require you to set up new relations manually each time.
I have made this test document which shows two methods to acheive what you are after. One is a button press and the other uses automation.
I hope that answers your question or at least points you in the right direction.
This is amazing!!! I tried out the first way and it works great It’s a bummer that there isn’t an easy way to have multiple selection options but this is WAY better than having to put everything in twice. Thank you for helping figuring this out and sharing!
Turning on Allow Multiple using the oringal method I posted could run into issues as the button’s only job was to set the Opposite term of this rows Opposite term to be ThisRow. If a Vocab term is used more than once then the originally set Opposite term would be overwritten.
E.g. A Vocab term of Multiple exsits with an Opposite term of Single. A new Vocab term is added for Individual and the Opposite term is set to Multiple. Now when you press the button to update Multiple to have an Opposite Term of Individual its original of Single is lost.
I have updated the doc with a new method that should get around this.
It’s a bummer that there isn’t an easy way to have multiple selection options but this is WAY better than having to put everything in twice. Thank you for helping figuring this out and sharing!
I am just beyond grateful for all your help! I just set it up and it works amazing!