I tried using the "number range" filter with a Google Spreadsheet source and the filter works for integers but not for floats with decimals ("2,7" or "2.7").
Instead it simply ignores the "." or "," and so it works like entering "27".
Could you please let me know why this happens and how to solve this?
Our company is located in Serbia and our working time is from 10:00 to 17:00 CET. business days.
Please provide me a temporary WP-admin login for your site where this happens, so we could log in and take a look ‘from the inside’ as that’s the most efficient way to see and resolve the issue. We do not interfere with any data or anything else except for the plugin (in case that’s a production version of the site), and of course we do not provide login data to third party. You can write credentials here just check Private Reply so nobody can see them except us.
I am sorry to disappoint you, but unfortunately when you are using float as a column type in order to find a value you must enter the value in filters with decimals, but in that case you can't use the Number Range filter when the source values' filter is different from what you set in wpDataTables. Like I mentioned in the previous reply, the number range filter recognizes only numerical values, and a decimal point. But, since the decimal point in Google Spreadsheet document is actually a comma, it can't see that point.
What you can do to make the number range filter work is change the formatting in Google Spreadsheets, so the number value is stored as 12.00 instead of 12,00. Then, you can change the Number Format in main settings of wpDataTables and it should be working normally.
I've created a simple Google Spreadsheet document and added some Float values (I believe you should have access if you want to try it for yourself Google Spreadsheet Float Test). I changed the format of that column to be Number 1,000.12 (attachment 1). Then, I changed the Number format in wpDataTables settings (attachment 2); and created a table using that Google Sheet table.
As you can see from attachments 3 and 4, the number range filter works, but only when the values are typed in fully. What I mean by this is - if I enter from 20.33 to 25 - it's going to say "No matching records found"; if I enter 20.33 to 25.0 it's also going to say "No matching records found", but when I add 25.00 it filters the correct data.
Please let me know if this solution works for you.
Hi there!
I tried using the "number range" filter with a Google Spreadsheet source and the filter works for integers but not for floats with decimals ("2,7" or "2.7").
Instead it simply ignores the "." or "," and so it works like entering "27".
Could you please let me know why this happens and how to solve this?
Thanks in advance.
Philip
Hello Philip.
Thank You for Your purchase.
Sorry for late response.
Our company is located in Serbia and our working time is from 10:00 to 17:00 CET. business days.
Please provide me a temporary WP-admin login for your site where this happens, so we could log in and take a look ‘from the inside’ as that’s the most efficient way to see and resolve the issue. We do not interfere with any data or anything else except for the plugin (in case that’s a production version of the site), and of course we do not provide login data to third party. You can write credentials here just check Private Reply so nobody can see them except us.
Best regards.
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
Hello again Philip.
I am sorry to disappoint you, but unfortunately when you are using float as a column type in order to find a value you must enter the value in filters with decimals, but in that case you can't use the Number Range filter when the source values' filter is different from what you set in wpDataTables. Like I mentioned in the previous reply, the number range filter recognizes only numerical values, and a decimal point. But, since the decimal point in Google Spreadsheet document is actually a comma, it can't see that point.
What you can do to make the number range filter work is change the formatting in Google Spreadsheets, so the number value is stored as 12.00 instead of 12,00. Then, you can change the Number Format in main settings of wpDataTables and it should be working normally.
I've created a simple Google Spreadsheet document and added some Float values (I believe you should have access if you want to try it for yourself Google Spreadsheet Float Test). I changed the format of that column to be Number 1,000.12 (attachment 1). Then, I changed the Number format in wpDataTables settings (attachment 2); and created a table using that Google Sheet table.
As you can see from attachments 3 and 4, the number range filter works, but only when the values are typed in fully. What I mean by this is - if I enter from 20.33 to 25 - it's going to say "No matching records found"; if I enter 20.33 to 25.0 it's also going to say "No matching records found", but when I add 25.00 it filters the correct data.
Please let me know if this solution works for you.
Best regards.
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