Sorting

[mhudd]

In a Portal I have a field "Priority"

The user enters a number manual into "Priority"

I would then like the Portal sorted numerically.

1

2

3

4

5

6

7

8

9

10

11

etc.

With records that don't have anything in the Priority field to be last on the list.

[Steven H. Blackwell]

OK, so tell the portal to sort on that field "priority" either descending or ascending, probably descending.

Is that what you're trying to do?

Old Advance Man

[simon1663]

This is not the most effective solution probably but it will do the job:

1. Define a summary field "MaxPriority" which will hold the maximum of Priority.

2. Define a calculation field called SortValue with formula like

If(Priority = 0 , MaxPriority+1 , Priority)

Make sure the result is Number

3. In the Define Relationship window - specify to sort related record by the SortValue field ascending.

It will work because if Priority is 0, then SortValue will become 1 more then the highest priority field. So, it will appear in last. Elsewise, it stays where it is supposed to.

Vote me if it helps...

[mhudd]

simon1663

Perfect!

[Fitch]

Since it wasn't mentioned, I feel obligated to point out the often-overlooked Sort by Custom Order Based on Value List. Just define a value list with all the numbers in it, and sort on that. Perfect!

[danjacoby]

Simplest solution: in the Define Relationships, sort the relationship by relationship::Priority, in ascending order.