Usually, I wish to sort by another field, ... it is not that I can see (field 1 or field 2).
By this limitation, my lists are usually unSort.
clarification in the imagen.
Too hard to input. The radio buttons are good. Possibly as a further option?
Hi Mr. Watson
It is restrictive to have to choose, ... between two fields (first or second). If the order depends on another factor (field), ... how do you solve it?
Draco How about a bit of both concepts?
Sorted Value List: Show only first field / Sort by second PLUS a choosable field, should you need a THIRD field:
…then we can all be happy
Ok Mr. Watson, what FM Inc. put both ( yes of course, in a moment.. )
My only problem is that I see duplicity of functionality. Faced with this, I prefer that a transcendental solution be implemented and not a symptomatic solution.
SHOW VALUE : Already is solved with the current situation.
SORT VALUE USING : Clearly unnecessary duplication occurs. Your proposal does not solve my problem, instead, my proposal meets your need, ... like mine.
pd: sorry my english
My understanding is that you cannot currently sort by a field which is not visually displayed in the list itself.
If we are asking FM to change this (so that the list can indeed be sorted by a field which is not being displayed) then it may be the case that there is very little difference in development overhead between this and MrWatson's idea Sorted Value List: Show only first field / Sort by second. If this is the case then why not go for the full solution Draco is suggesting? I believe it could achieve things which MrWatson's idea could not.
I suspect MrWatson's reservation is the popdown menu of sort fields, as this is not normally how we select fields in FM. I would expect FM to give us a third window, or another dialogue window only for this purpose, to select the sort field from, or to leave unselected and "default" sort the way it does atm.
If you want to get really funky then how about allowing the developer to add as many fields as he/she wants to a value list (separated by tabs or vertical dividers) and for each one choose using a checkbox if it is displayed in the value list and another to choose if it is entered into the field upon selection? On top of this you would have Draco's idea of the choice of sort field, selected by whichever means (indexable fields only of course). Wouldn't need to create text fields with multiple values anymore...
By the way, I'm assuming you're both aware of this solution in the meantime?
If not then let me know and I'll paste a couple of custom functions which make it easier to implement.
Retrieving data ...