Lotus Designer - @Trim undone when using sorting

Question

My application have a table that have 3 columns to be used in View:

In View, all 10 rows will share a column using show multiple values as separate entries and @Trim.

I want to sort Expired By column in ascending order, but when I did that and refresh my view, it seem to have undone the @trim

Is @Trim not compatible with sort functions?

Answer 1

Change your "Expired On" column formula to

@ToTime(@Trim(
@If(cert != ""; @Text(certend); "") : 
@If(cert_1 != ""; @Text(certend_1); "") : 
@If(cert_2 != ""; @Text(certend_2); "") : 
@If(cert_3 != ""; @Text(certend_3); "") : 
@If(cert_4 != ""; @Text(certend_4); "") : 
@If(cert_5 != ""; @Text(certend_5); "") : 
@If(cert_6 != ""; @Text(certend_6); "") : 
@If(cert_7 != ""; @Text(certend_7); "") : 
@If(cert_8 != ""; @Text(certend_8); "") : 
@If(cert_9 != ""; @Text(certend_9); "")))

It adds certend values only if related cert values are not empty. As you want to sort by this column too you have to use it as DateTime and not as Text type.

Change order of columns. Only the first of the multivalue columns can be sorted. The following multivalue columns have to be unsorted (sort: "none").