Forum Discussion

KevinO_Boyle's avatar
KevinO_Boyle
Qrew Cadet
7 years ago

How do I number the lines on a report extract?

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.
APIs and custom code
App builders
Ask about Quickbase functionality

3 Replies

Sort By
  • QuickBaseCoachD's avatar
    QuickBaseCoachD
    Qrew Captain
    7 years ago
    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.