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
Summary reports can essentially do ranking because if you do a summary report but basically break on every record, you can have a field with a formula value of 1 and display that as running totals down the page. So they self number from 1 to .. whatever.
- Hey so I am trying to rank based off of a calculation. My calculation returns a value (i.e. 100,115, 50,000, 10,000, 2103) I want those values ranked 1 through 100 based Highest to lowest. For example, 100,115 would equal 1 and 2103 equals 100, if there were 100 records.
- See the answer directly above your post.
"Summary reports can essentially do ranking because if you do a summary report but basically break on every record, you can have a field with a formula value of 1 and display that as running totals down the page. So they self number from 1 to .. whatever. "
I believe that is the only solution, but I know if does not actually create a field on the record. - I need a field that can be used on multiple reports
- To the best of my knowledge that cannot be done natively. You would need to have someone write you a script.
There might be something possible with Automations. How many ranks would it ned to handle. ie 100? or is it much higher. A lower number might be possible natively with Automation. I'm currently in Israel so bedtime, so I will sleep on that thought. - Much Higher 690
- Thanks Good Night
- If you need that high, then it will need script. Contact me off line for recommendation for developers who can do that, if you have a budget to pay for a script to be done.
