Re: Ranking On Reports

Yes you can do this with script:

Counting Daisy Petals
https://haversineconsulting.quickbase.com/db/bj2vba44z

The default report shows the image onload field [Index] as empty:

Default Report
https://haversineconsulting.quickbase.com/db/bj2vba46e?a=td

But on the List All report the image onload field [Index] is dynamically filled in:

List All
https://haversineconsulting.quickbase.com/db/bj2vba46e?a=q&qid=1

Normally the image onload field is named [-] but since we only want it to show up on reports it is used as the column header we named it [Index].

Pastie Database
https://haversineconsulting.quickbase.com/db/bgcwm2m4g?a=dr&rid=393


Notes:

(1) this is a very green solution as we recycle the space taken up by the image onload field to display actual index data:

[iol] & "module.js" & [/iol]
&
"<span class="QBU_Count"></span>

(2) Note that Index is not saved in the table as it will change depending on which report is displayed. Compare the List All report to this one focusing on the delta and epsilon records:

Contains Letter "l"
https://haversineconsulting.quickbase.com/db/bj2vba46e?a=q&qid=5