Solved: Sort list Dereferences by another column, without ... - Page 2

PGold

Hi all,

I want to have a Show column inside an order form with a sorted list of previous orders for the selected customer.
As I understand from the appsheet documentation, I will need to make a separate virtual column to generate a sorted list and only then i can dereference the list in my show column.

My question is, is there a way to avoid making this virtual column as I am really trying to avoid any expensive virtual columns, where not absolutely necessary?

Steve

You could use a normal (non-virtual) column instead, which would only recompute when the row is being updated, but then you have unnecessary storage.

If the sorted list is only needed in form views, you could wrap the expression that generates the sorted List of Ref values like IFS(("Form" = CONTEXT("ViewType")), ORDERBY(...list of previous orders..., ...orderby parameters...)).

View solution in original post

Sort list Dereferences by another column, without extra virtual column