Implementing a stack rank function?
I need to implement a stack rank of a list of items in a quickbase table. Is there a way to write a formula to update all records stack ranks when the value is set for a new item?
Forum Discussion
Basically I want to keep all records in a table ordered, so if i had 10 items, they would be numbered 1, 2, 3, ...10. If user inserts a new record and assigns it as 5, then existing 5, 6, 7,... 10 would all get incremented by 1.