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.

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

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...

simon1663

Perfect!

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!

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