Sort concatenated values in table view not working
Hi, I have a parent table "Programmes" and a child table "Works" .
In the "Works" table I have a number field called Order and then a field which combines the WorkTitle with the order (Order+"-"+Title). This is so I can decide in what order the works are for each programme because it can change.
In the "Programmes" table view I need a column which lists the Titles in the order they have been set via the order field. (1-TitleA, 2-TitleB, 3-TitleC...) but when I create a function for that column such as:
sort(concat(Works.TitleandOrder)) they still get sorted by their ID.
Any ideas?
3 replies
-
Hi,
Could you try the following?
concat((Works order by Order).TitleandOrder)
-
Any attempt to order by in the formula of the view is ignored. The sort is determined by the setting of the columns in the view. You will need to show the Order and set this column.
Regards John
Content aside
- Status Answered
- 8 days agoLast active
- 3Replies
- 29Views
-
3
Following