Solved: Can a Ref list be sorted with the most recent firs... - Page 2

HCF · 10-29-2021 12:53 AM

Hi, I have a table that use a Ref to the Contacts table so I can select a contact for the activity. It looks like this:

The EnumList is sorted alfabetically, however I should like that the newest records shows at the top - is the a way to acheive this?
Also, when one or several contacts from the contacts table are selected, I should like an easy way to deselect without having to clear all - is that possible?

Aurelien

Hi @HCF

If you have a creation_timeStamp, that can be done using the Valid_If field and expression:

Something like:

ORDERBY(table[Key], 
  [Creation_TimeStamp],
  false
)

About this:

You may want to explicit the “easy way”. If you want for example the selected ones to appear first, I’m afraid that will be tricky.

View solution in original post

Can a Ref list be sorted with the most recent first