Pastie Database - User Defined Page

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
------------------------------