Sort based on value list.

[nightdesigns]

I'm trying to create a sorted listed based on a custom sort order. I can get everything to work, except that i'm mixing times (in the format or mm:ss) and text. How can i specify where to put the times in my sort list (they'll be in numerical order). Everythign is in text format.

Happy t-day

-j

[Vaughan]

Seeing an example would help.

I'd be tempted to enter stuff like this in sepatrate fields (use a time field for the time) so they can be sorted apropriately. Then create a calc field that concatenates them for display.

[nightdesigns]

Example of my sort order:

Name

Time (mm:ss format, anything, in order from 0)

FP

SOT

OOP

FMI

A calc field is out of the question since i'm boucning things all over the place with portals and would have to do a major rewrite to get it to work.