Just purchased the plugin and I was setting up a test sheet to see how well it will populate date from Google Sheets. I went through your documentation and did everything that was advised, however, currency data and calculated totals are not showing up in WPDataTables. Any help you can provide will be appreciated.
Well, after messing around for a few minutes I figured it out. Change Data type to string and currency values are now showing. Easy Peasy, sorry to bother.
Can you please tell me is everything is working fine.
If you have sings for currency in the fields like $ etc. then the wizard would not recognize it as a number, it will be string.
Also you can import just the numbers from the file and use Cell content prefix or suffix to add that currency sings. More information in our documentation.
Just purchased the plugin and I was setting up a test sheet to see how well it will populate date from Google Sheets. I went through your documentation and did everything that was advised, however, currency data and calculated totals are not showing up in WPDataTables. Any help you can provide will be appreciated.
Well, after messing around for a few minutes I figured it out. Change Data type to string and currency values are now showing. Easy Peasy, sorry to bother.
HI cerebralyawn,
Thank you for your purchase.
Can you please tell me is everything is working fine.
If you have sings for currency in the fields like $ etc. then the wizard would not recognize it as a number, it will be string.
Also you can import just the numbers from the file and use Cell content prefix or suffix to add that currency sings. More information in our documentation.
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