Skip to main content
Question

Row Counter

  • September 19, 2023
  • 0 replies
  • 334 views

Forum|alt.badge.img+4

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 be accessed?)



------------------------------
Jeff Rogerson
------------------------------
This topic has been closed for replies.

MarkShnierYou
Forum|alt.badge.img+22
  • Quickbase Alumni
  • September 19, 2023

This can be done with a Formula Query but only if the short on the report is 100% predictable and you don't use any dynamic filters.  

The only other way that I know of is to create a field that calculates to 1 called [Row]

then you need to contrive a summary report, which will actually break on every single record, and include that as a field to summarize on the report, and said that field to be displayed as a running total down the report.  

So basically, the trick is to make a summary report which gives you all the rose and all the columns that you would have had on your table report.



------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------