APPLICATION DESIGN

Overriding alphabetical sorting with a hidden column
The sorting column does not need to be visible. Sometimes you may want to use a hidden column as your sorting column. To hide a column, check the Hide box on the Advanced tab of the Column Properties box.

For example, a Service Request form contains a Priority field, which uses the following choice list:

Urgent
High
Medium
Low

You want the By Priority view to sort documents by the value in the Priority field, but you don't want them to appear in ordinary alphabetical order (High, Low, Medium, Urgent). You want users to see Urgent-priority documents at the top of the view, High-priority documents next, and so on.

You create a column that:


You add a column to the right of the hidden column that:
See Also