Comments Bill started the conversationJune 18, 2024 at 6:18pmThe data entered in the forminator form is $160.18 currency. I have set up the table as a float field with two decimals it is showing 168.018,00.The sql database is showing it correctly as 168.18 1,846Miloš repliedJune 19, 2024 at 8:46pm Hello,This is most probably an issue with the current Number Format and Decimal places selected in your settings. Please go in your Main Plugin settings/ and change the Number Format to the one you need; Also double-check how many decimal places you need and set this accordingly as well. Let me know if that solves the issue. Thank you.Kind Regards, Miloš Jovanović[email protected] Rate my supportTry 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 Bill repliedJune 20, 2024 at 2:12pmThat was it, Thank you Milos you can close the ticket. Miloš replied privately Sign in to reply ...
The data entered in the forminator form is $160.18 currency. I have set up the table as a float field with two decimals it is showing 168.018,00.
The sql database is showing it correctly as 168.18
Hello,
This is most probably an issue with the current Number Format and Decimal places selected in your settings.
Please go in your Main Plugin settings/ and change the Number Format to the one you need;
Also double-check how many decimal places you need and set this accordingly as well.
Let me know if that solves the issue.
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
That was it, Thank you Milos you can close the ticket.