How do I number the lines on a report extract?

  • 0
  • 1
  • Question
  • Updated 9 months ago
  • Answered
I’m building a tool that auto-create the Work orders needed to replenish our inventory kanbans. The report will always have different items on it. In the extract report I need to number the lines 1 to n where n ranges from 2 to 99.

I’m looking for suggestions to accomplish this - or to partner with someone who could develop a solution.
Photo of Kevin O'Boyle

Kevin O'Boyle

  • 602 Points 500 badge 2x thumb
  • hopeful

Posted 9 months ago

  • 0
  • 1
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 51,306 Points 50k badge 2x thumb
If you just want to sequentially number the lines on a report, if there are not too many columns you can make a Summary report which would break on something unique like Record ID#. So it would be a summary report in name only as each line would be a separate record. 

Then if you have a Dummy field called Line # with a formula value of 1, then you can show that on the report and set that field to be a running total down the page.
(Edited)
Photo of Kevin O'Boyle

Kevin O'Boyle

  • 602 Points 500 badge 2x thumb
Thanks. And to make sure, the running total column will show up in the csv export?
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 51,306 Points 50k badge 2x thumb
Yes, you can export to Excel