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!
This question is about the implementation/handling of Google spreadsheet columns including currency data type.
As you wrote in the original WP topic, the current implementation handles such cells as strings:
"All columns that include any other character other than numbers will be considered as string columns, so you can’t link to, or import a table that has a prefix or a suffix.
The data in the column has to contain only numbers, and when you link that table with wpDataTables, you can add a prefix and/or a suffix in column settings."
My question: are you planning to implement a better currency field implementation? The reason why I’m asking is that there’s a typical scenario:
1. We want to import a live Google spreadsheet to wpDataTables, one theat includes columns with currency&number data type.
2. We need these columns’ data type to remain 'currency' because this same column is used by other 3rd party APIs as well.
With this scenario, the current way of implementation (removing the currency symbol in Google, and re-add it in the wpDataTables UI) is not a workable solution.
Thanks in advance for your information on this.
Hi, Tobias
Thanks for reaching out to us.
- I can see what you mean, and I agree, this is something that could improve the use-case scenario which you described.
- At this time, unfortunately, as you saw on the WP topic, this is not possible to achieve with any of our built-in functionalities, but I will pass this to the developers as a suggestion to work on in the future.
You can add your personal suggestion to this as a built-in feature on this link https://wpdatatables.com/documentation/feature-suggestion/ and our developers would place it on their "TO-DO" list.
As more customers request a feature, it gets pushed quicker on the list. We always strive to make our product better and deliver the most value to our end users, so we carefully review each suggestion.
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
👍 Thanks for your follow-up, Miloš - this ticket can be closed now.
Hi, Tobias
If anything else happens, please don't hesitate to open a new ticket.
Thank you
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