Hello. We are getting an issue with our Google Sheets integration. The sheets are both public, but unfortunately they are not showing on the website via WPdataTables. If you go to the website homepage, please just scroll down to the bottom of the page and notice the WPdataTables area where the spreadsheets are missing.
We are hoping you can assist us with figuring out what is going on. Thank you.
The issue is probably related with your Google Spreadsheet. You have narrow some columns (B, D, F...) but it is not possible to have empty columns. You should not create Google Spreadsheet like that. Each column should have at least column Header name. Also I suggest you also not to skip rows in the spreadsheet (but this will not cause errors in wpDataTables). Please take a look at the example how Google Spreadsheet file should look at this link.
Thanks that helped! I have one more question. The table is now showing up, but there are several empty rows showing up at the top of the table when viewing on the website: http://cy-fair.setmy.site/
This is probably happening because you have empty rows in the Google Spreadsheet. Can you please send me the new Spreadsheet or check if you have any empty rows in it?
Milos is currently on a vacation so I will help you out. Can you please try now I edited the spreadsheet and this is the result . ( attachment)
The issue was that you have a new line between sentences in column UNIT DETAILS You entered them like this : Equivalent to small hall closet. Drive up access.
and it should be entered like this:
Equivalent to small hall closet. Drive up access.
Because of that Google spreadsheets recognize them as a new row or break and that is why you had that issue.
Hello. We are getting an issue with our Google Sheets integration. The sheets are both public, but unfortunately they are not showing on the website via WPdataTables. If you go to the website homepage, please just scroll down to the bottom of the page and notice the WPdataTables area where the spreadsheets are missing.
We are hoping you can assist us with figuring out what is going on. Thank you.
Hi partyparty,
Thank you for the purchase.
The issue is probably related with your Google Spreadsheet. You have narrow some columns (B, D, F...) but it is not possible to have empty columns. You should not create Google Spreadsheet like that. Each column should have at least column Header name. Also I suggest you also not to skip rows in the spreadsheet (but this will not cause errors in wpDataTables). Please take a look at the example how Google Spreadsheet file should look at this link.
Milos,
Thanks that helped! I have one more question. The table is now showing up, but there are several empty rows showing up at the top of the table when viewing on the website: http://cy-fair.setmy.site/
Hi partyparty,
This is probably happening because you have empty rows in the Google Spreadsheet. Can you please send me the new Spreadsheet or check if you have any empty rows in it?
Hi Milos,
Here is the spreadsheet: https://docs.google.com/spreadsheets/d/1w-6aw1zlU10Pf8paA4rUs6ZM2nyXCTwbw3LcY--8KRY/edit?usp=sharing
I made the spreadsheet publically editable so you may edit it if you need to. It is a test.
Hi partyparty
Milos is currently on a vacation so I will help you out.
Can you please try now I edited the spreadsheet and this is the result . ( attachment)
The issue was that you have a new line between sentences in column UNIT DETAILS
You entered them like this :
Equivalent to small hall closet.
Drive up access.
and it should be entered like this:
Equivalent to small hall closet. Drive up access.
Because of that Google spreadsheets recognize them as a new row or break and that is why you had that issue.
Best regards.
Kind Regards,
Miloš Jovanović
[email protected]
Rate my support
Try our FREE mapping plugin! MapSVG - easy Google maps, interactive SVG maps and floor plans, choropleth maps and much more - https://wordpress.org/plugins/mapsvg-lite-interactive-vector-maps/
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
After some searching, I found out in another ticket that we can use <br> to resolve the issue.
Thanks for this wonderful plugin!