I have some odd scenario where I have a choice that writes a value to a temporary user specific field. But the real value that should be written is in another column in another table.
I created a single row relation to the destination columns and tried choosing to write to that relation, but it doesn’t show up in the list of available options.
It is a temp solution until I come with cleaner design.
Thanks
A Set Column action can write through a single relation, but that would require a button or something like that to execute the action.
Depending on your use case, you should be able to add a Custom Collection sourced from that relation, and then place your choice component inside the custom collection container. That way you can update the column value directly instead of needing a temporary user specific column.
very nice trick! thx