In a doc I’m working on, two relation columns (both relations to the same underlying table) are intended to be combined into a third column. The third column should display the rows from the original two columns, sorted by a particular column in the underlying table.
I have it working fine when both columns to combine contain data, but it isn’t working when one of those columns is empty.
I’ve prepared a minimal example of the issue in this doc. When the ‘Combine A and B’ button is pressed, the Result column is intended to be populated with the contents of Column A combined with the contents of Column B, sorted according to the ‘Sort by This’ value.
Any help getting this working would be appreciated!