How do I number the lines on a report extract?

Question

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.

quickbasecoachd · Answer

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.

kevino_boyle · Answer

Thanks.  And to make sure, the running total column will show up in the csv export?

quickbasecoachd · Answer

Yes, you can export to Excel

Forum Discussion

How do I number the lines on a report extract?

Related Content

Roundup whole number

Extract Date and Comment from prepend log entry field

Calculating number of days between two date fields

Add hyphens to phone number field

Reference Numbers Displaying Instead of Names in QuickBase