August 10, 200421 yr Is anyone knows if it's possible to create unsorted value list? I need to create a value list consisting of all time values from another file, but the times are formatted in the text fields. I don't want the times be sorted as text.
August 17, 200421 yr I take it your time field is defined as a "Time" field? If it's a true Time field, it should sort in order of the durations/times. Do you not want that? (If it's a *text* field with time values, then you should consider turning it into a time field, and simply *displaying* it in the way you prefer, or creating a calc to show text that fills it out the way you like.) At any rate, you can always sort a value list by some other field than the ones whose values you're actually selecting. You can make and sort on a calc field which is a NUMBER type field, but which returns the value from the time field manipulated in whatever way you like. If your record has a "Creation Date" or "Creation Time" field, you can sort on *that* field, which is roughly what FileMaker would do when records are "unsorted"...
Create an account or sign in to comment