How to display at best a table with a large amount of columns

[chofra02]

Hi,

I'm totally new to Fabrik and must admit that my skills are far too low to use as I would like.

I'm operating a site called indoorrowers.org for our community and we want to publish there a kind of historical races searchable database under the menu Race Results.
I have setup a db table called results and had so far everything running.
Afterwards I tried to display this table on the site using Fabrik.
I got a basic table displayed but apparently it is not well setup because due to the large amount of columns the display of the column is overriding the width of the page and looks just scrap.
So I was thinking about having a horizontal slide bar. I found an entry in the Wiki but never found in the default.php what would need to be replaced.
So now a question for the experts:
All the columns from date to time are to be displayed on each kind of device, the splits could be first hidden and then shown if the users toggle them on.
So what would be the best way to do this?
I honnestly ask you this as I'm really tired of the kind of "try and error" game and I spend actually my private time in this as a volunteer..
Thank you for any help or comment.

Cheers, Sebastien

 

[troester]

In list settings "Filters" you can enable "Toggle columns", so the user can toggle off/on elements and groups.
List is starting with all columns on, if you want to start with some columns off you have to create a custom template.

In list settings "Layout"/Responsive CSS you can add CSS classes to elements (columns) to show on phones/tablets...

 

[chofra02]

Hi troester,
I know already both options and use them as good as I can. Would somebody maybe know how to display the splits results as text over the row when the user is pointing on the time for example?

Thx

 

[troester]

About the scrollbar:
create a custom list template (copy bootstrap folder, rename), edit default.php
Add
...
<div style="width:440px;overflow:auto">
<table
...</table>
</div>

 

[chofra02]

Thanks troester, the slide bar works quiet fine now , I just increased the number of pixel as it looked a bit wired.
Now I have 2 last issues:
a) I would like to have dropdown filters for each column under the headings. I tried to setup the heading filter option but the result is that i cannot enter any value in the filter fields.
Is there a way to get this working like a kind of dropdown list of availabe values?

b) When I select the detail view for a record, I always get the record details for the first place rowers of that event instead of the selected rowers details.
I think that this has to do with the primary key or something like this ... no?

thanks for your help!

Cheers

Sebastien