AnsweredAssumed Answered

Self-Adjusting Rank?

Question asked by director@charlesmoore.org on Dec 5, 2014
Latest reply on Dec 5, 2014 by philmodjunk

Title

Self-Adjusting Rank?

Post

Is there anyway to create "self-adjusting ranking" for records?  For instance:

 

 

 

 

 

 

 

uniqueID = 100  "Orange"             Rank = 2

uniqueID = 101  "Apple"                Rank = 1

uniqueID = 102  "Pear"                  Rank = 3

So if one were to change:  uniqueID = 100  "Orange"             Rank = 1

Then, automatically

uniqueID = 100  "Orange"             Rank = 1

uniqueID = 101  "Apple"                Rank = 2

uniqueID = 102  "Pear"                  Rank = 3

Or

If one were then to add a new record:  uniqueID = 103  "Pineapple"             Rank = 2

Then

uniqueID = 100  "Orange"             Rank = 1

uniqueID = 101  "Apple"                Rank = 3

uniqueID = 102  "Pear"                 Rank = 4

unique=ID = 103 "Pineapple"       Rank = 2

Also, if one were to delete a record, such as "Pineapple" from above, then:

uniqueID = 100  "Orange"             Rank = 1

uniqueID = 101  "Apple"                Rank = 2

uniqueID = 102  "Pear"                 Rank = 3

If possible, I would prefer this to accomplished with a calculation field rather than a script or a sorting function.

Outcomes