Forums

I created a table using CCV5; I am having a difficult issue as I need to display Serial Numbers on the table. I have attached a screenshot of the table.

How can I display the row number / serial number of each table row?

Kindly help

Hi atanunu,

What's the row number ?

Are you able to use v6 instead ? it has much more flexibility.

Best regards,
Max

Hi Max,

I was able to replicate the form with CCv6 following the instructions on the FAQ tutorial.

I still need the to number the records retrieved and displayed; starting from 1 - X.

Kindly assist.

Thanks Atanunu

Hi Atanunu,

In the columns fields of your table add "counter".

In the "columns views" add this:

counter:{view:row_count}

Create new "HTML" view, name it "row_count" and use the following code:

{var:table_view_name.key}

The counter will reset on each new page though, if you need a continuous counter then a patch may be needed, let me know if so.

Best regards,
Max

Thanks so much sir for your response.

The numbering starts from 0 instead of 1. I will be glad to get corrections for this for future references.

[attachment=73180_20170223124023_screenshot-www-probun-com-2017-02-23-13-39-08-png.png][/attachment]


I need the continuous counter on each new page.

Thanks for your outstanding support

Hi atanunu,

The 0 start can be fixed, instead of {view:row_count}, use {fn:row_counter}, then under "Functions", add a new PHP function and name it "row_counter", in the code section use this:

echo 1 + $this->get("table_view_name.key", 0);

Best regards,
Max

Thanks Sir,

The code above works perfectly. The table is seen below with SN

[attachment=73180_20170225073217_screenshot-www-probun-com-2017-02-25-08-31-40-png.png][/attachment]

Please how do I add navigation
[attachment=73180_20170225073423_screenshot-www-probun-com-2017-02-25-08-33-28-png.png][/attachment]

and a custom link (Details) to the table.
[attachment=73180_20170225073452_screenshot-www-probun-com-2017-02-25-08-33-46-png.png][/attachment]

Thanks for your continuous support

Hi atanunu,

The paginator can be added using a pagination view, add a new view of type paginator and then call it at the "event" after you call the table view.

For the details link, you need a "link" view, and it should be pointed to the "view" event, then in the "view" event you will need to call a "details" view, after you add it in the views section of course.

Best regards,
Max

Thanks Sir,

I have been able to achieve the paginator and the details as seen below :
[attachment=73180_20170226083810_screenshot-www-probun-com-2017-02-26-09-37-38-png.png][/attachment]

I need the counter to be continuous on new page rather than start from 1 again as seen below:
[attachment=73180_20170226084016_screenshot-www-probun-com-2017-02-26-09-24-04-png.png][/attachment]

Thanks for your support