How can we sort the order of the drop down li...

(tsuji koichi) #1

How can we sort the order of the drop down list by either ascending or descending? I made one column type to “Ref”, and can get the drop down list from the table which is referred to.

But the order of the data is not cleanly sorted out as users keep adding new rows. How can we sort the drop down list dynamically?

(Aleksi Alkio) #2

You can use ORDERBY expression with the ref column in Valid_If. The parameters to this function are OrderBy(ListOfRecords, SortColumn, True/False).

(tsuji koichi) #3

Thank you. I wondering which column’s valid if we should put this expression. Whenever we create the ref, the virtual column is automatically being created, should we put in there? Or the column we set the column type as “Ref”?

The expression of orderby, what does “list of records” mean?

(tsuji koichi) #4

I played around and find out how I form the expression and where to input now!

(Aleksi Alkio) #5

Good :slight_smile: