A very simple way - I'm sure there are others:
So you have number field called Priority. You will need a new number field (call it Assign) which can hold the new 'assigned' position. You will need a calculation (result is number) called c_Rearrange with:
Case ( NOT Assign; Priority & ".1" ; assign )
After you have entered your new numbers in the Assign field, script would be:
Sort [ c_Rearrange ; ascending ]
Replace Field Contents [ Priority ; Get ( RecordNumber ) ]
Replace Field Contents [ Assign ; "" ]
UPDATE: Corrected typo
Of course the calcualtion can also be:
Case ( NOT Assign; Priority + .1 ; assign )
... which would have been more proper (and more efficient) since Priority is a number field. I had just woken up. :smileytongue:
Thank you so very much for all this. It is a big help. I am not quite ready to do this yet, as the people involved have to see if they want it. The things our families ask of us!!
I have "assign" "priority" "c_rearrange" fields.
what do you mean by this portion?
What is the " Get (RecordNumber) " in this script? I can't locate it