lotus-noteslotus-formulalotus-designer

Lotus Designer - @Trim undone when using sorting

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

enter image description here

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

enter image description here enter image description here enter image description here

enter image description here

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

enter image description here

Is @Trim not compatible with sort functions?

Solution

  • 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"). enter image description here