Hello John

Thank you for your interest in wpDataTables.

If you create a table linked to a Google Spreadsheet, there's cache on Google's side, so it will take up to 15 minutes for the table to pull the data.

If you create a table using Google Sheets API, there will be no cache in pulling the data/

Hi again John

The plugin will only pull what it sees, so text.

1. You would be able to add images if you modify the content of the cell in Google Sheets and add <img> tags, like:

<img src="url-to-the-image" width="40">

That way, wpDataTables will pull the image from the URL and display it in a table.

2. Same thing - you would need to use anchor tags in this case:

<a class="custom-button" href="custom-url">hyperlink text</a>

Then, in the "Custom CSS" section, under Customize tab above the table, you would be able to define that "custom-button" class with custom CSS, making it look like a button. You can configure the style of the button on this page, and then just overwrite the class with your class.

3. Our crypto currencies table is a database table, so it's not live, but a simple, manually entered table. The best approach (if you don't need editing) is using Google sheets, JSON or PHP arrays.

Hi again John

I don't believe that it would slow down the table any more than if it was able to actually pull the images from the spreadsheet. After all, they are hosted somewhere, so pulling them directly from the spreadsheet, or reading a link wouldn't make much difference. To be honest, I believe that using the <img> tag would even be faster since it would exclude the rendering on the spreadsheet, and only use it once - when the table is rendered.

Unfortunately, I don't have any example sites from our customers that I could share with you. We have some user tables on our showcase page, but none of them actually show live cryptocurrency data. If you can do calculations in the JSON file, and prepare a PHP Adapter that would return that data, you would be able to use a serialized PHP Array as the source. This requires some coding skills, and I wouldn't be able to help you with that.

Hi again John

The issue with the number of rows that can be loaded in a table linked to an existing data source (Google Sheets, Excel, CSV, etc) is related to the hosting plan, server performance, amount of memory, etc.

We've got a lot of memory, and a premium hosting plan, so it works better than most WordPress websites. There's no defined limit here, as it all depends on all the factors mentioned above, so on your site it may slow down after 8.000 rows, and crash after 10.000 rows, while on someone else's site it may crash after 2.000 rows - there's no telling.

All the data from the sheet is pulled into wpDataTables, so by default (for example), this will be one filtering value:

BTC, ETH, XRP, BCH, LTC, BNB, EOS, LINK, XLM, TRX, PAXG

This will be another one:

EUR, GBP, USD

And so on:

You can, however, copy the value from the cell (again):

BTC, ETH, XRP, BCH, LTC, BNB, EOS, LINK, XLM, TRX, PAXG

And in some text editor FIND ", " and replace with "|", so it looks like this:

BTC|ETH|XRP|BCH|LTC|BNB|EOS|LINK|XLM|TRX|PAXG

Then, in column settings of wpDataTables, in the Data tab, change "Possible values for column" from "Read from table on page load" to "Define values list", and paste the values separated with the pipe |, and they'll be added as single values:

So, when you add all values here, you can enable "Multiselectbox" filter in the Filtering tab in column settings, and you'll be able to filter rows by manually selecting values from this column.

Hi again John, I'm glad to hear that!

Sorry if I didn't specify this clearly. You need to go to the column settings of wpDataTables, in the Data tab, change "Possible values for column" from "Read from table on page load" to "Define values list", and paste the values separated with the pipe, like this:

When you paste them here, they will be saved as individual entries:

Hey John

Thanks for the purchase. Could you please open a new ticket in wpDataTables section, now that you purchased the plugin? You can add the URL to this ticket in it, so I know it's you. You can also ask for me in the body of the ticket, since I'm familiar with the situation, in case the ticket is assigned to one of my colleagues.

I can't log in with the credentials you provided, unfortunately:

As for the table, I see you've included filters in the footer, and they're all text filters - there's no selectbox, multi-selectbox, or any other filters that'd pull the values from the defined list.

You can enable "Show filters in a modal" in the Sorting and Filtering tab above the table, to see them above the table, or you can move them in the header in wpDataTables settings.