Hi,
I have a read only grid with recordType as data source. The total records are N, more than 5000. I have the need to show a column in the grid with a progressive index, from 1 to N.
Is there a way to achieve this using the recordType and without loosing some functionalities like user filters, excel export, etc.?
Thanks!
Discussion posts and replies are publicly visible
Ooooh this is a fun question! I think your best bet here is to use the information in fv!currentPage, since that has the start index and identifiers of the current page. Here's an example column for how I was able to get it to work:
a!gridColumn( label: "Index", value: fv!currentPage.startIndex - 1 + wherecontains(fv!identifier, tointeger(fv!currentPage.identifiers)) )
It works! Thank you Peter!
..I add a question: is it possible to export the grid including this new "virtual" column to Excel or at this point do I necessarily have to move on to creating a view?
Peter Lewis said: fv!currentPage,
Wow, somehow I'd always missed that this is a thing that can be used in the Value parameter in a!gridColumn(). I note that the only place it's mentioned in the documentation (like, at all) is in the Validations parameter for the whole grid.
Yep, it's pretty useful! I'll see if we can get the documentation updated to make it more clear where you can use it