How do you sort within the Simple List Widget

zag · ‎07-16-2020

HI guys,

I am trying to get the Simple List Widget to sort properly. My Display field is Short Description, the Secondary Field is u_trending_status, number

What ends up coming out is an Ascending Sort by Short Description. I thought the first Secondary Field was the Sort field. Anyone know whats going on?

Chander Bhusha1 · ‎07-17-2020

Hi Zag,

Can you open sp_instance_vlist.LIST. This table hold the simple list widget isntance open the record for which you have created a simple list.

Bring the Order by field on the from using configure - form layout.

Open the list:

Search with the table for which you have crated the list.

Open the from: Configure form layout -- bring order by field on the form.

and update the field to which you want the order.

mark helpful and correct if it helps

Thanks,

CB

View solution in original post

ericcrawford · ‎10-08-2021

For those wondering you can do as Chandler mentioned, but it will default to Ascending. If you would like to have the list sorted by Descending then you need to add the "Order direction" field to the instance form (Configure > Form Layout > Move "Order Direction" from left to right section > Save)