Any solution would be DOA once users start playing with the report. In theory you could have a formula query that mimics the same filters as your report and ranks it in some fashion with those filters/sort behavior, but then if a user were to apply a dynamic filter or re-sort the report in another format, the values of that column would not re-shuffle since those aren't data binding to the actual row you'd have mis-aligned numbers.
Original Message:
Sent: 09-12-2023 08:09
From: Mark Shnier (Your Quickbase Coach)
Subject: Auto numbering report rows
I'm pretty sure there's not a way to number rows on a report where the Sort and filters are unknown in advance. There are ways to number rows on the report but we would have to understand the filters and the sort on the report.
------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
Original Message:
Sent: 09-12-2023 06:21
From: Allan S
Subject: Auto numbering report rows
This would give you a row number.
var text Query = "{3.LTE.'" & [Record ID#] & "'}";
Size(GetRecords($Query))
------------------------------
Allan S
Original Message:
Sent: 09-12-2023 03:09
From: Sam Rozenfeld
Subject: Auto numbering report rows
No, because Record IDs are permanent. I am trying to add a sort order number.
------------------------------
Sam Rozenfeld
Original Message:
Sent: 09-12-2023 00:45
From: Adam Krzyzanek
Subject: Auto numbering report rows
Does [Record ID#] suit your need?
------------------------------
Adam Krzyzanek
Original Message:
Sent: 09-11-2023 21:22
From: Sam Rozenfeld
Subject: Auto numbering report rows
Hello,
Can a simple incremental row number be added to the report? Regardless of how the report is sorted, I want to see a record number starting from the top of the current sort order. Any help is greatly appreciated.
------------------------------
Sincerely,
Sam Rozenfeld
------------------------------