Numbered List

[crisraguilar]

Is there a way to add a field or something that would create a numbered list in a results page. I have a results page that is 25 records long and it would be nice if they were numbered so that when I resort them they get renumbered according to that sort.

Any help?

[bahar_vm]

As I understand you want to have a column containing sequential numbers and regenerate the numbers each time the results is resorted.

This could be achieved with a Java Script on an HTML block of the results page. So basically you will set a variable to 0 in the header of the results and in the HTML block just increment the variable and write it with document.write JS statement.

Best,

Bahar M.

[crisraguilar]

Can someone please put the code here so I know what to put in? I know where to put it but not exactly sure what to put.

Thanks!

[dhc]

You can achieve what you are asking for by implementing custom javascript in the Caspio datapage described as follow:

1. In the header section of the result page declare

var count = 0 ;

2. In the body of the dp create a html block contains the follow code:

count = count +1 ;

document.write(count) ;

Hope this helps.

dhc

[crisraguilar]

Excellent! Works exactly as I needed it.

Now.. although it works great lets solve another issue with that numbered list. My results page has 2 pages. I have a total of 38 records that are devided into these 2 pages. The first 25 on the first page and the next 13 on the second page. The first page has a numbered list 1 - 25 and the next page starts over and numbers it 1 - 13.

Is there a way to get that second page to number it 26 - 38?

[bahar_vm]

Ok, enable Advance options and Passing parameters on the DataPage and enable "Bridge and external parameters" then put the following into the header:

var page='[@cpipage]';

if(isNaN(page) || page == "") {

var count = 0 ;

}

else {

var count = (parseInt(page) - 1)*25;

}

Best,

Bahar M.

[crisraguilar]

The problem with that is that then I am unable to have a "search form", I would have to have "pre-difined" criteria".

[bahar_vm]

Cris,

It works for both, no matter if you have search form or a predefined criteria, just try it.

Best,

Bahar M.

[crisraguilar]

If I simply did as you told me this would have worked. I did try it but when I tried it I deleted the old code and inserted the new code. That is why it didn't work.

Thanks! This is a useful bit of javascript!

[AtayBalunbalunan]

Record index in search results is available by now. Please refer to this article for more information: https://howto.caspio.com/datapages/reports/creating-a-report-datapage/

Scroll down to Configuring the Results Page section, then Display Options.