Sorts based on Custom order list?

[Bruce Herbach]

Hi,

I am working on a script where I want a Custom order sort based on a list of Values. For this I selected the Custom order and set up a value list.

Since the list only has 6 entries I typed in the entries. I also tried setting up a table with the values in the desired order but this didn't work either.

The issue is that the data doesn't appear to be sorted based on the order of items in the Custom list.

So the short question... Is it possible to sort this way and get the desired result? If so how?

The sort is based on two values, the first is a classroom name. This is the custom part. The second is a student name. This is a standard Ascending order sort.

Thanks very much.

Sculler

[Fitch]

Try sorting on the custom list manually. It should work - I suspect the problem is with your script, or else the values in the records don't match your value list items. Perhaps it's a data type mismatch? It does require a custom list, values from a table will sort alphabetically. What does your list look like?

[Bruce Herbach]

The list is a series of text values based class room names. Here is the list...

St. Rose

Union

RPI

Siena

MIT

NYU

The class rooms are named after universities. I have verified that the text and case are correct. I even copied and pasted the entries in to the list.

A manual sort of the data seems to result in the same problem. At this point I'll take another look at it in the morning.

Thanks for the help.

Sculler