Forum Discussion

Qrew Member

3 years ago

Pastie Database - User Defined Page

Hello, I am currently trying to create a ranking column on one of my reports and found some documentation in past forums regarding a method for this in the Pastie Database (I will include these below...

APIs and custom code

formula queries

Qrew Commander

Pretty much anything you find for the IOL technique is no longer possible as written in the guides because Quickbase disabled the use of JavaScript easily in the apps. It is still possible to use in other ways but you will need to utilize service workers I believe and it is quite a bit more involved as you will need to come up with your own solution there and then implement what you have linked into it.

Qrew Member

3 years ago

That's a bummer. Thank you for letting me know. Do you know of any other ways to make a ranking report?

------------------------------
Kaity Strong
------------------------------

MarkShnier__You
Qrew Champion
3 years ago
if your dataset is not too large like thousand of records and not 10's of thousands you can use Formula Queries. The info below was posted by @Elwyn Dow . who I believe is a developer at Sympo.

I have other examples and also there is a nice video by Ms Junkie. https://www.youtube.com/watch?v=sHU8pB38N2Y Her enthusiasm in the morning is better than a morning coffee. @Quick Base Junkie

https://community.quickbase.com/communities/community-home/digestviewer/viewthread?MessageKey=85f95242-4b4d-4a61-9f07-1a1c80f53a73&CommunityKey=d860b0f8-6a48-487b-b346-44c47a19a804&tab=digestviewer#bm85f95242-4b4d-4a61-9f07-1a1c80f53a73

Ranking formula using the new Query functions. Will rank records based on numeric field. Ranks top 10, top 100, etc – or every value…

var bool descOrder = true;            // true if ranking from high to low, otherwise false
var number maxrank = 0;             // 0 to rank every number, else 10 to rank 1 through 10, 100 to rank 1 through 100, etc
var number fieldId = 17;              // the field id of the numeric field being ranked - CHANGE AS NEEDED
var number rankThis = [number field]; // the numeric field being ranked - CHANGE AS NEEDED
var number rank    = If($descOrder, Size(GetCellValues(GetRecords("{"&$fieldId&".GT."&$rankThis&"}"),$fieldId))+1,
                                    Size(GetCellValues(GetRecords("{"&$fieldId&".LT."&$rankThis&"}"),$fieldId))+1);
If($maxrank=0,$rank, If($rank<=$maxrank,$rank,null))

------------------------------
Elwyn Dow

------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------
- KaityStrong
  Qrew Member
  3 years ago
  This works great! Thank you so much.
  
  ------------------------------
  Kaity Strong
  ------------------------------