Create a record ranking number in a view/report | Community
Skip to main content
PavlinPa1
PavlinPa1
New Participant
July 13, 2021
Solved

Create a record ranking number in a view/report

  • July 13, 2021
  • 3 replies
  • 1540 views

Hello,

How can I create a record ranking number in a single view or report?

For instance, there is a view or report created with 10 records. Then, I sort those in a certain way, e.g. by date. At that point, I'd like to have a record number in the first column to show me 1, 2, 3, ..., 10. In that case, I may refer to... "Record 5, 7, and 8..." without counting the records/lines on the screen. It could be more complicated, such as "Record 16, 22, and 34...", etc. Then, I may change the sorting, e.g. by % Complete. I want to have the ranking number from 1 thru N (top to bottom), again. And son on and so forth.

Is there a way to add a (static) line/record ranking number column in a view or report with sorting being changed? Thank you.

Best,

+Pavlin

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Best answer by Doug_Den_Hoed__AtAppStore

Nope, not natively, Pavlin.

Regards,

Doug

3 replies

Doug_Den_Hoed__AtAppStore
Doug_Den_Hoed__AtAppStore
New Participant
July 17, 2021

Oh, well that's entirely different Pavlin,

If I'm allowed to cheat and use dark matter, we could whip up a Magic Report solution for you that presents the data in a grid layout similar to what you'd see in the Workfront report (heck, maybe even read the definition from it), but when its then presented, add a line number entry in the first column for easy reference; and even alternate the grid row colors etc. if you want to get fancy.

That said, it's such a good, simple idea, I'd think that maybe @Jeremy Flores‚ could consider grafting it into a future release of Basic Views (and Reports), and/or @Matt Thomas‚ might like to incorporate it into the upcoming New Reporting Experience; but of course, I'll leave it to them to comment further.

Regards,

Doug

Matt-Thomas
Matt-Thomas
Employee
July 20, 2021

This is a fantastic idea @Pavlin Panayotov‚ and @Doug Den Hoed‚! Having the ability to toggle on line numbers for rows in a table seems like a great feature to incorporate in the new reporting experience. @Pavlin Panayotov‚ do you mind scheduling some time with me to make sure I have fully captured your idea and then talk about possible ways to implement it https://calendly.com/matt-thomas-wf/30min. Thanks!

PavlinPa1
PavlinPa1Author
New Participant
July 20, 2021

Hi Matt, Just scheduled time with you. Chat soon. Thank you.

PavlinPa1
PavlinPa1Author
New Participant
July 16, 2021

Doug, What about with some programming? Do you have any ideas? ;)

Doug_Den_Hoed__AtAppStore
Doug_Den_Hoed__AtAppStoreAccepted solution
New Participant
July 14, 2021

Nope, not natively, Pavlin.

Regards,

Doug

Terms & ConditionsAccessibility statement

Loading footer...