Need horizontal scrollbar for shortcode wpdataaccess

Hi,

To add a horizontal scrollbar add the following JSON in column “Table options (advanced)”:
{"scrollX":true}

This link might be helpful as well:
https://datatables.net/forums/discussion/comment/128441/#Comment_128441)

You might also consider to make your table responsive. Just set output to responsive, number of columns to 0 and type to modal or collapsed.

Let me know of this helps…

Best regards,
Peter

I am somewhat new to WP Data Access so having trouble locating “Table options (advanced)”.

After further searching I did find the Table options (advanced) option in Data Publisher. Although, I copied {“scrollX”:true} there, it is still not showing the horizontal scrollbar.

Hi,

Can I see your table? Doe you have a public URL?

The plugin uses jQuery DataTables to populate the table. From the “Table options (advanced)” column you can add any available jQuery DataTables option and function. You just need to make sure that you enter valid JSON. You can find the documentation here:
https://datatables.net/reference/option/

Best regards,
Peter

Hi,

Our website is mostly restricted to logged in members only, so we would have to do a TeamViewer screen sharing to see the table(s).

In looking at the Data Publisher edit with the Table options you suggested, the Test Publisher button does NOT show the horizontal scrollbar and neither does the page with the shortcode on it UNLESS the F12 key is pressed. If the F12 key is pressed, the horizontal scrollbar does present itself, but only five columns show. Also with the F12 key pressed, the column label spacing and the data rows spacing are mismatched.

Can you make the table responsive? A responsive table will be adjust to your device, so you’ll be able to view the table data even on a tablet or smartphone.

Best regards,
Peter

I am pretty sure the table is set for responsive in Data Publisher.

Can you add two screenshots:
(1) A screenshot of your publication settings (Data Explorer)
(2) A screenshot of the table (a web page I guess)

Thanks,
Peter