We're Moving to a New Support Platform – Starting June 1st!
We’re excited to let you know that starting June 1st, we’ll be transitioning to a new support system that will be available directly on our product websites – Amelia, wpDataTables, and Report Builder. In fact, the new support platform is already live for Amelia and wpDataTables, and we encourage you to reach out to us there.
You'll always be able to reach us through a widget in the bottom right corner of each website, where you can ask questions, report issues, or simply get assistance.
While we still do not offer live support, a new advanced, AI-powered assistant, trained on our documentation, use cases, and real conversations with our team, is there to help with basic to intermediate questions in no time.
We're doing our best to make this transition smooth and hassle-free. After June 1st, this current support website will redirect you to the new "Contact Us" pages on our product sites.
Thanks for your continued support and trust – we’re excited to bring you an even better support experience!
Hello! I am going to be creating multiple tables and charts from Google Spreadsheets. However I am having the following difficulties:
1) The chart engine requires that I have only one string column type
2) If I convert the column type to integer, it messes up the table.
What am I doing wrong?
Hi rbalcom,
Thank you for your purchase.
1) Yes, only one string column type is allowed to be in the chart, because if there are more string types the chart can not be created because it can not populate x or y axes with 2 string values and calculate it on the chart preview.
2) Can you please send me one spreadsheet that you are trying to make a chart so I can take a look.
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
HI, here is a sample of the type of spreadsheet we are using. I am hoping to link to Google Sheets
HI rbalcom,
The "issue" is that all of the columns are string type, and unfortunately the chart can not be created with the only string columns.
About the bad formating it is happening because when you change the column type to string the values are not displayed correctly because of the other type.
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
Is there a way to change the column type without ruining the sheet?
Hi rbalcom,
When you import some file in our plugin, our plugin automatically guess the column types for the columns in the table. In case when it does not guess it correctly you can change manualy the column type in the column settings.
Can you please explain me more what did you mean with the post below because I did not quite understand.
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
OK, dummy here.
1) When I "publish this sheet to the web"
and use the link. WPdata tables says there are no rows.
https://docs.google.com/spreadsheets/d/e/2PACX-1vSG5FrTWc83Y7iku-4QSSZS_VJpNKMUbUM9F2J6VmpEj4NXZ9OUTOEdTBi6i8TJcvbImNvvqGt_C-dF/pubhtml?gid=0&single=true
2) If I create a shareable link, then it recognizes there are rows. However it removed one column and all of the columns are string type.
3) If I change one of the columns to Integer, then the chart does not display correctly.
Please see examples here
https://www.marketmastersprogram.com/chart/
Hi rbalcom,
The issue is that the google spreadsheet file is not properly created. You must remove all of the formatting from the file.
Here is the link from my spreadsheet that I created from your file.
You can see how you can create a proper file in our documentation.
About the chart:
Chart can not have just string column types and you can not create a chart from the file that you send me because all of the columns are strings. You also can not change the string type from your file to integer because the string columns can not be displayed like integer.
So to create chart you must have column which contain numbers.
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