Can you explain a little more about this variable?
Does it work by incrementing for every row that will be outputted in the export? Say in the export template it has ${names.all} and 5 names as exported, will that built in variable index them in a way so the outputted excel sheet is like this(index in one column, name in another)
That variable is for creating a row index. If you have a report template where you want a column that would have row IDs, like this Google Sheet for example - the first column 1, 2, 3, 4, 5, 6, etc. you would use that variable.
How does it deal with row offsets? Like what if the first 4 rows are used for column headings and details, and the row index variable is added to row 4, but it needs to start from 1. How does the variable handle this? Can you guys please create a more in-depth doc on this variable?
wpDataTables can only have one header, and that's the column's header.
Custom headers and descriptions will not be taken into account, so each row below the header will start from "1". You can filter the table, and enable "Follow table filtering" when creating the Report, so the table displays only from row #4, and it would work only in that way.
The variable is new, and our developers will add it to the documentation soon.
Every feature suggestion goes directly to our developers and they are constantly working on improving the plugin so if there is anything else you would like to see added in the future please take the time to leave your suggestion following this link.
This question is regarding report builder.
I was looking up the changelog https://wpreportbuilder.com/whats-new-changelog/ for RB and saw that in v1.3 a new built-in variable was introduced called: ${wdtrowindex.all}
Can you explain a little more about this variable?
Does it work by incrementing for every row that will be outputted in the export? Say in the export template it has ${names.all} and 5 names as exported, will that built in variable index them in a way so the outputted excel sheet is like this(index in one column, name in another)
1 Name
2 Name
3 Name
4 Name
5 Name
Hi TheLoneDev
Thank you for reaching out to us.
That variable is for creating a row index. If you have a report template where you want a column that would have row IDs, like this Google Sheet for example - the first column 1, 2, 3, 4, 5, 6, etc. you would use that variable.
How does it deal with row offsets? Like what if the first 4 rows are used for column headings and details, and the row index variable is added to row 4, but it needs to start from 1. How does the variable handle this? Can you guys please create a more in-depth doc on this variable?
Hi
wpDataTables can only have one header, and that's the column's header.
Custom headers and descriptions will not be taken into account, so each row below the header will start from "1". You can filter the table, and enable "Follow table filtering" when creating the Report, so the table displays only from row #4, and it would work only in that way.
The variable is new, and our developers will add it to the documentation soon.
It works as expected thank you. I remember asking for a feature like this a while back its nice to see that it was implemented
You are most welcome
Every feature suggestion goes directly to our developers and they are constantly working on improving the plugin so if there is anything else you would like to see added in the future please take the time to leave your suggestion following this link.