I have been trying to link my Google spreadsheet to my WPdatatable. I copy the link from the top of the page. When it uploads, there are only 2 columns. How do I connect the entire sheet? Attached are pictures of the spreadsheet and the WPtable. Thank you.
Your Google Spreadsheet doesn't have a correct structure.
The first row of the spreadsheet is used to generate headers, and since you have only one cell in the first row, the plugin creates that as a column header, and it uses the next empty cell to create another header.
To pull all the data from the spreadsheet, you would need to delete the 1st row, and have all your Spreadsheet's headers (in the second row) move up.
The number format needs to be the same in your Google Spreadsheet, and in wpDataTables. So, if you have floats in the Google Spreadsheet table like 4,0 or 3,5, you need to go to wpDataTables settings, and set the number format to 1.000,00.
I have been trying to link my Google spreadsheet to my WPdatatable. I copy the link from the top of the page. When it uploads, there are only 2 columns. How do I connect the entire sheet? Attached are pictures of the spreadsheet and the WPtable. Thank you.
Hello Daniel
Thank you for your purchase.
Your Google Spreadsheet doesn't have a correct structure.
The first row of the spreadsheet is used to generate headers, and since you have only one cell in the first row, the plugin creates that as a column header, and it uses the next empty cell to create another header.
To pull all the data from the spreadsheet, you would need to delete the 1st row, and have all your Spreadsheet's headers (in the second row) move up.
Kind Regards,
Aleksandar Vuković
[email protected]
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
Thank you so much. That worked! Is there an easy way to fix numbers. We put in a score like 4, or 3.5, but there are coming out like, 4,000 or 3,500
You're welcome, Daniel
The number format needs to be the same in your Google Spreadsheet, and in wpDataTables. So, if you have floats in the Google Spreadsheet table like 4,0 or 3,5, you need to go to wpDataTables settings, and set the number format to 1.000,00.
Kind Regards,
Aleksandar Vuković
[email protected]
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