Not the first time I have asked this question... but really doesn't make sense to me why Quickbase wouldn't have the ability to show line numbers (ranking) on reports (and column identifications for that matter) similar to a spreadsheet. After all it does count the number of records in any given report and reports it at the top of the report. We run a golf course and use Quickbase as an on-line database to score events, and to be able to auto number rows, would allow us to show player rankings in an event .... See attached graphic for example.

The solution is to build this report using a Summary Report instead of a Table Report. Include a field which is called Ranking, which is a formula field of a formula of 1, and show it as a running total down the report.

That I don't understand Mark. In a summary report, can I show multiple fields of the same record? Example, I have the players name, their score for each hole (18 fields) possibly their front 9, back 9 totals and gross score? and then sort based on their gross score and individual hole scores (to break ties via retrogression)?

Yes you can do this with script: Counting Daisy Petalshttps://haversineconsulting.quickbase.com/db/bj2vba44z The default report shows the image onload field [Index] as empty: Default Reporthttps://haversineconsulting.quickbase.com/db/bj2vba46e?a=td But on the List All report the image onload field [Index] is dynamically filled in: List Allhttps://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 Databasehttps://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

I will look back on my emails with you. At the time I did believe it was possible to do.

Way way way, above my expertise.

Ranking On Reports | Qrew Discussions

25 Replies

JeffRogerson
Qrew Cadet
10 years ago
I would love to send you the table.
QuickBaseCoachD
Qrew Captain
10 years ago
I recall that I thought this through once and though I could get what you wanted, natively.
JeffRogerson
Qrew Cadet
10 years ago
Okay, I give up, could I beg your assist on writing the script? I tried to write on as a calculated column on a report, but I either get a syntax error, or a "1" on every record. Thanks in advance.
JeffRogerson
Qrew Cadet
10 years ago
& yes, the Pastie Database example is exactly what I am looking for. So I tried to create an index field, (formula - numeric), but when I fill it with your script example I get a syntax error?
QuickBaseCoachD
Qrew Captain
10 years ago
I'm still wanting to prove that this can be done natively if you give me access to your app or a copy of the app. No charge. It's s brain teaser.
_anomDiebolt_
Qrew Elite
10 years ago
> prove that this can be done natively

Mark I wanted to help you out on your native quest to solve this problem. I mean there has to be a native solution since the QuickBase formula language is Turing Complete. To the extent you may need to check your formulas for correct syntax I wanted to share this online Turing Machine Simulator that may speed up your efforts. Here is a shared link for a Turing Machine Simulator that will check for balanced parentheses in this simple example formula:

LastDayOfYear(Todate("August 4, 2009"))

Turing Machine Simulator
http://morphett.info/turing/turing.html?949cc8652811af0a84d8

Just go to the above link and click the Run command.

Enjoy ...
On computable numbers, with an application to the Entscheidungsproblem by Alan Turing http://www.cs.virginia.edu/~robins/Turing_Paper_1936.pdf

Breaking the Code: Biography of Alan Turing
https://www.youtube.com/watch?v=S23yie-779k
_anomDiebolt_
Qrew Elite
10 years ago
You have to provide more info for me to debug this. Share an application if you want but make the application as simple as possible and no more.
MeredithMoore5
Qrew Assistant Captain
7 years ago
How did this go, out of curiosity?
- JeffRogerson
  Qrew Cadet
  7 years ago
  It still hasn't. I am looking for a simple formula to number the rows in a table report.
- QuickBaseCoachD
  Qrew Captain
  7 years ago
  I know it�s not what you want to hear, but if a client wanted it bad enough you could installed Juiced EF+ as it has an option to number lines.
- JeffRogerson
  Qrew Cadet
  7 years ago
  Hey Mark, you must be saying "not this guy and this same issue again".
  
  I guess what gives me angst on this is table reports already count records, so why not just have a built in feature showing the counter as an available system generated field that can be turned on or off in reports. Seems simple to me.
  
  But great to hear from you again.

Forum Discussion

Ranking On Reports

25 Replies

Related Content

Summary Reports

Restful API Report digesting JSON

embedded reports

Report Formulas

Rank Using Query