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?
Solved! Go to Solution.
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.
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.
Thanks - donโt figure where to put the OrderBy expression though?
Here
Sorry - got it - โSuggested Valuesโ of course
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.
User | Count |
---|---|
38 | |
35 | |
27 | |
23 | |
18 |