Problems with Pagination and Tables

Ask the community
,
1

Hello,

I’m working on using a table to display data from a database collection. I have got it to work and show all data; however, my problem lays in the coding behind the pagination option.

I’m attempting to limit each page to only show 10 rows , yet regardless of row count the navigation “< Page 1 of 4 >” cuts off about a third of the bottom row on the table. I have adjusted row heights, page height ot accomodate for space and other such basic tactics but from what I can work out it is part of the table element.

Is there a way around this?

Live working example:

Coding used: 


$w.onReady(function () {

    $w("#casestudytable").pagination = {"type": "pagination", "rowsPerPage": 10};

});

Thank you in advance for your help.

2

Have you just tried adjusting the height of the results table so that it accommodates the height of the ten rows along with the additional height space for the pagination tab at the bottom.

So for example, if you had ten rows at 50mm height each, then the table display will be 500mm+ pagination tab height (eg. 50mm too), so your results table needs to be at least 555mm to allow for all displayed rows and pagination tab.

However, you will need to add on a few extra mm to the total height if you have included any spacing within each separate rows.

3

Hi givemeawhisky,

I cannot adjust the height of the table as it imports data from a database. The Height value is greyed out at a total of 303 with three rows; however, on the main website when looking at the published version it shows 10 rows like the code suggests.

I’m beginning to wonder if the pagination sits on top of the table due to the way in which in works in the backend part of wix we cannot touch.