Hi, I'm trying to add a column of Float with a range filter, but when I come to search or add a number in new entry, like 70, it writes 0,70 instead. In Integer this does not happen, but I need Float, to write incomplete numbers like 7.5.
That should not be happening. If you have a float column, you would be able to use the number range filter with float values. Could it be that you're using different formats?
For example, if your numbers are formatted as 15.000,00 and you type 7.5 it may cause an issue because the decimal separator is different. Try using the separator you see in the table, and see if that works.
If it does, and the format is wrong, you can change it in wpDataTables settings.
Go to wp-content/plugins/wpdatatables/assets/js/wpdatatables/wdt.columnFilter.js, and on lines 265, 269, 433 and 437 you will find this:
input type="number"
Change that to:
input type="text"
Then go to wpDataTables settings/Custom JS and CSS and turn off "Use minified version of JavaScript" and delete cache from your website. It will work normally after that, but please note that in this case, your users will be able to add anything in the filter (even text), but it will work with any number format.
Hi, I'm trying to add a column of Float with a range filter, but when I come to search or add a number in new entry, like 70, it writes 0,70 instead. In Integer this does not happen, but I need Float, to write incomplete numbers like 7.5.
Hello Refael
Thank you for your purchase.
That should not be happening. If you have a float column, you would be able to use the number range filter with float values. Could it be that you're using different formats?
For example, if your numbers are formatted as 15.000,00 and you type 7.5 it may cause an issue because the decimal separator is different. Try using the separator you see in the table, and see if that works.
If it does, and the format is wrong, you can change it in wpDataTables settings.
Kind Regards,
Aleksandar Vuković
[email protected]
Rate my support
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
Sorry, there's a workaround for this after all:
Go to wp-content/plugins/wpdatatables/assets/js/wpdatatables/wdt.columnFilter.js, and on lines 265, 269, 433 and 437 you will find this:
Change that to:
Then go to wpDataTables settings/Custom JS and CSS and turn off "Use minified version of JavaScript" and delete cache from your website. It will work normally after that, but please note that in this case, your users will be able to add anything in the filter (even text), but it will work with any number format.
Kind Regards,
Aleksandar Vuković
[email protected]
Rate my support
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