Can a Ref list be sorted with the most recent first

[HCF]

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 · Accepted solution]

Hi @HCF

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

help.appsheet.com

ORDERBY()

Sort row references

Something like:

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

About this:

HCF:

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?

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.

[HCF]

Thanks - don’t figure where to put the OrderBy expression though?

[Aurelien]

Here

[HCF]

Sorry - got it - “Suggested Values” of course

[Aurelien]

I would rather pick “valid_If” instead, but it’s up to you.
Valid_If admits either a Yes/No expression, or a List expression.