Row Counter
Can anyone council me if it is possible to create a report formula to count and display the row number in a report? (I know Quickbase counts the number of records in a report, but can this counter b...
Forum Discussion
The above only works unfortunately until someone makes an adjustment or adds a filter to play with the data view at which point the value of the Row # would still be the same since its based on the entire data set, not on the data in the report. Mark's suggestion is the only native solution / loophole that QB can do, otherwise the only other option is to do a custom code page and you could do something like a API_GenResultsTable or REST API report run and then display it with an additional column inserted to show the row # custom.
------------------------------
Chayce Duncan
------------------------------
Thanks everyone.
I use QB at my golf course for a zillion things including event scoring.
In this case, I was scoring a high school tournament in which we had to identify the low overall golfer (easy), and also the low four golfers from each school, calculate the sum of their four scores, then rank against the other schools.
My app has two tables. Parent is the list of schools, child is the list of competitors and where the hole scores are tabulated.
I wanted Quickbase to identify the four low players for each school on the child table and then I'd simply have a summary field on the parent table to tabulate each schools (4 person) team total then sort on this counter total and report.
I couldn't automate the task, so I simply added a checkbox to the scoring table, sorted the scores by school and gross score (with a tie breaking methodology) and checked the check box for the first four scores of each school. So the summary simply counted the check marks from each school.
Simple with my small data set.
But it drives me crazy I can write a formula in an excel spreadsheet to automate this exact task in minutes, but on Quickbase, it's so complicated.
Jeff
------------------------------
Jeff Rogerson
------------------------------
I think that you can do this with the relationships in summary fields. When school has many players. Do a summary of the minimum of the score.
I think that you can do this with the relationships in summary fields. When school has many players. Do a summary of the minimum of the score.
Look that up down to players. Call it best score #1.
New summary field of the minimum record ID with score = best score #1..
Call That Record ID of player with best score.
Look that up down to players.
Now calculate best score number two. This will be the minimum of the scores subject to the condition that the score is greater than or equal to best score number one, and the record ID is greater than record idea of player with best score number one.
then you continue on with the pattern above, which identified the record idea of the player with best score number to. Then you keep doing that until you identify the record IDs of all players with the best scores.Then you can summarize the total best scores for players wear. The record ID is equal to the record ID of best player scored number one or two or three or four.
You can also flag who are the players are because they record IDs will match the record ID of the player with best score number one or two or three or four.
I hope this is readable. It was mostly dictated on my iPad. Feel free to post back if you get stuck anywhere.
------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------
