HI. I am trying to create a new data table using info from a google sheet. Your directions were very easy to follow but when I got to the last step to create a new Data Table, I got the Error: Please provide a valid 2-dimensional array. I saw a similar question on your public support boards but I could not understand the answer. I'm not really sure where to start trouble shooting.
I was able to get some of it solved but now there are other problems. To solve the first problem, I found that WP Data Tables didn't like that my last column didn't have a header.
But now I have some new problems.I have created a table from a google sheet. However the order the table displays is not the order in google sheets. It has changed to alphabetical by first column.
Also the prices are all coming in as zero. Oddly enough they are also using commas instead of a decimal. Is there any way to fix this?
One other thing. I tried scrapping the whole thing and starting a new google sheet. When I tried making a new table. I got an error message "Forbidden". Is there a limit on how many tables can be linked to google or is it something else?
wpDataTables has sorting enabled by default, and by default it uses the 1st column for sorting. If you were to disable sorting for the whole table in the "Sorting and Filtering" tab above the table, the sorting from Google Sheets would be used.
As for the new sheet - please make sure the sheet is published to the web, and that you have headers in all columns. The Forbidden error is coming from your server (it understood the request, but it's denying to follow it), not from wpDataTables. The plugin doesn't have a limit on the number of tables, regardless of the type.
HI. I am trying to create a new data table using info from a google sheet. Your directions were very easy to follow but when I got to the last step to create a new Data Table, I got the Error: Please provide a valid 2-dimensional array. I saw a similar question on your public support boards but I could not understand the answer. I'm not really sure where to start trouble shooting.
I was able to get some of it solved but now there are other problems. To solve the first problem, I found that WP Data Tables didn't like that my last column didn't have a header.
But now I have some new problems.I have created a table from a google sheet. However the order the table displays is not the order in google sheets. It has changed to alphabetical by first column.
Also the prices are all coming in as zero. Oddly enough they are also using commas instead of a decimal. Is there any way to fix this?
One other thing. I tried scrapping the whole thing and starting a new google sheet. When I tried making a new table. I got an error message "Forbidden". Is there a limit on how many tables can be linked to google or is it something else?
Hello Ed
Sorry for the late response.
I'm glad to hear you resolved the initial issue.
wpDataTables has sorting enabled by default, and by default it uses the 1st column for sorting. If you were to disable sorting for the whole table in the "Sorting and Filtering" tab above the table, the sorting from Google Sheets would be used.
As for the new sheet - please make sure the sheet is published to the web, and that you have headers in all columns. The Forbidden error is coming from your server (it understood the request, but it's denying to follow it), not from wpDataTables. The plugin doesn't have a limit on the number of tables, regardless of the type.
Kind Regards,
Aleksandar Vuković
aleksandar.vukovic@tmsproducts.io
Rate my support
wpDataTables: FAQ | Facebook | Twitter | Instagram | Front-end and back-end demo | Docs
Amelia: FAQ | Facebook | Twitter | Instagram | Amelia demo sites | Docs | Discord Community
You can try wpDataTables add-ons before purchasing on these sandbox sites:
Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables | Master-Detail Tables
I forgot about the number format, Ed.
To change that please change the number format in wpDataTables settings:
Kind Regards,
Aleksandar Vuković
aleksandar.vukovic@tmsproducts.io
Rate my support
wpDataTables: FAQ | Facebook | Twitter | Instagram | Front-end and back-end demo | Docs
Amelia: FAQ | Facebook | Twitter | Instagram | Amelia demo sites | Docs | Discord Community
You can try wpDataTables add-ons before purchasing on these sandbox sites:
Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables | Master-Detail Tables