Firstly, I would like to sincerely apologize for the delayed response as we have been experiencing an unusually high number of tickets. I am sorry that it has taken longer than usual to respond to your concern and your patience is highly appreciated.
-
At the moment, our plugin does not have a built-in option to hide the trailing zeroes from Float columns in our dataTables.
to see if someone may be already suggested this feature. If you can't see it, feel free to add your suggestion there, and as more people vote, the feature will move higher on the priority list.
You can certainly follow our changeLog page if you'd like ( it is also available in the plugin dashboard), where we state any changes/new features/bug fixes during updates;
and our newsletter, so you're informed about new features, bug fixes, freebies, etc.
-
For the time being, i can only suggest to try some custom workarounds,
for example if you use SQL based tables, such as Manual or SQL Query based,
you can try to run SQL Queries in the Database Management Tool /
or try other methods to change the data in the source database table.
For example, i found this article that seems useful on How to
Of course, you can also search on resources such as Stack Overflow to see if other users managed to achieve something similar in the source Datatabase Tables.
How do I hide the trailing zeros of a float in a table? (External data source)
See screenshot.
Thanks!
Attached files: Screenshot 2023-05-04 083112.jpg
Hi, Erez.
Firstly, I would like to sincerely apologize for the delayed response as we have been experiencing an unusually high number of tickets. I am sorry that it has taken longer than usual to respond to your concern and your patience is highly appreciated.
-
At the moment, our plugin does not have a built-in option to hide the trailing zeroes from Float columns in our dataTables.
If you wish to see a native option for this,
please feel free to search on our suggestions page,
to see if someone may be already suggested this feature. If you can't see it, feel free to add your suggestion there, and as more people vote, the feature will move higher on the priority list.
You can certainly follow our changeLog page if you'd like ( it is also available in the plugin dashboard), where we state any changes/new features/bug fixes during updates;
and our newsletter, so you're informed about new features, bug fixes, freebies, etc.
-
For the time being, i can only suggest to try some custom workarounds,
for example if you use SQL based tables, such as Manual or SQL Query based,
you can try to run SQL Queries in the Database Management Tool /
or try other methods to change the data in the source database table.
For example, i found this article that seems useful on How to
Remove trailing zeros in decimal value with changing length in MySQL.
Of course, you can also search on resources such as Stack Overflow to see if other users managed to achieve something similar in the source Datatabase Tables.
I hope this helps.
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