Hi - We would like the formatting used in the filters to match what is in the data table. For instance at this url we have have the second column called Annual income required (indexed). This is an integer column so we added the $ prefix and it has the thousands separator.
However, it only shows the raw numbers in the filter (eg 50000 instead of $50,000). If we change to string and Define values list and try to add the values as $50,000 etc then this does not work because they are comma separated so it will only have a value of $50 rather than $50,000.
We have a similar problem with the next column (Return on savings %). These are also integers and so the filter shows as just "3" instead of "3%"
When we loaded these as "3%" instead of "3" then the filter did not work.
About the thousand separator it should be shown in filters. Are the credentials that you provide early is still active, because we need access to check this?
Prefix and suffix of the content are available only in table, not in filters.
Hi Milan - Your credentials will not still be active. We have wasted a lot of time on this already and don't have time to set you up a staging environment again.
I think it is a significant oversight that prefix and suffix are not shown in both table and filters.
Also, it is very bad usability that adding the Define values list is comma separated because that means we cannot add comma figures (eg $50,000) as a filter. We cannot see any workaround so either we have the filters without $ and commas, but in the correct order, or we can have them look correct (when Strings) but not in the correct order (see screenshot). I'm surprised that such basic requirements have not been covered already.
And please don't forget the bug with the filters with a % not working. This previously worked because we previously created this table with filters that worked. Now it doesn't.
At the end of last week we didn't work because of the national holiday.We are located in Serbia and our working time is from 10:00 to 17:00 CET. business days.
We are still investigating what cause the issue. Thank you for your patience.
Sorry for late response. Like I explain you in previous post last week we have national holiday and for weekends we are not working. There was some error with filters that contain % and we fix that you can check. If you still getting errors just clear the browser cache.
About the second issue that you have numbers in filter without thousands separator, I can confirm that is a bug on our side. This will be fixed for next update version.Thank you for reporting this.
b) When will the next update version with the fix for the thousands separate be available? I understand you cannot say exactly but roughly, will this be one day, one week, one month?
c) Regarding the issue where the prefix and suffix are not included in the filters, please can you explain the logic in this? And if you agree that this is an oversight and also needs to be fixed, when will this be in place?
Issue was not disregarded, we was debugging code on your site which have some time to find what cause the issue.
a)Can you please check now? It was not applied on minified js files that are generated from original files. We turn this off and now is working.
b)Like you said I can't tell you exactly when it will be release, because it depends of implementing new features and testing plugin. We will try to be as soon as possible.
c)Whatever you enter in the “Cell content prefix” (E.g. $ sign, or other currency) will be rendered in each cell of this column before the actual cell value; whatever you enter in the “Cell content suffix” (E.g. “%” or “pcs.”) will be rendered after the actual cell value, and this will not affect sorting, filtering, or any other column functions.
So in filters will be populated with actual values of table without prefix and suffix. They are predicted for visual presentation only.
We are located in Serbia and our working time is from 10:00 to 17:00 CET. business days.
a) I am glad that tables is working fine.
b) I describe to you in previous post for what prefix and suffix are predicted. This feature is implement because a lot of customers request some addition information for integer or a float column. If the original data for integer or float column contain something else except the numbers, it will be became string column. With string column you can't use features like calculating totals, minimum, maximum and average values in WordPress Tables and also making formula columns.
Hi - We would like the formatting used in the filters to match what is in the data table. For instance at this url we have have the second column called Annual income required (indexed). This is an integer column so we added the $ prefix and it has the thousands separator.
However, it only shows the raw numbers in the filter (eg 50000 instead of $50,000). If we change to string and Define values list and try to add the values as $50,000 etc then this does not work because they are comma separated so it will only have a value of $50 rather than $50,000.
We have a similar problem with the next column (Return on savings %). These are also integers and so the filter shows as just "3" instead of "3%"
When we loaded these as "3%" instead of "3" then the filter did not work.
Please can you advise how these can be fixed.
Cheers, Rob
Hi Robert,
Thank you for your purchase.
About the thousand separator it should be shown in filters. Are the credentials that you provide early is still active, because we need access to check this?
Prefix and suffix of the content are available only in table, not in filters.
Kind Regards,
Isidora Markovic
wpDataTables: FAQ | Facebook | Twitter | Front-end and back-end demo | Docs
Amelia: FAQ | Facebook | Twitter | Amelia demo sites | Docs
You can try our wpDataTables add-ons before purchase on these sandbox sites:
Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables
Hi Milan - Your credentials will not still be active. We have wasted a lot of time on this already and don't have time to set you up a staging environment again.
I think it is a significant oversight that prefix and suffix are not shown in both table and filters.
Also, it is very bad usability that adding the Define values list is comma separated because that means we cannot add comma figures (eg $50,000) as a filter. We cannot see any workaround so either we have the filters without $ and commas, but in the correct order, or we can have them look correct (when Strings) but not in the correct order (see screenshot). I'm surprised that such basic requirements have not been covered already.
And please don't forget the bug with the filters with a % not working. This previously worked because we previously created this table with filters that worked. Now it doesn't.
https://www.superguide.com.au/boost-your-superannuation/superguide-retirement-reckoner
Hi Robert,
Sorry for late response.
At the end of last week we didn't work because of the national holiday.We are located in Serbia and our working time is from 10:00 to 17:00 CET. business days.
We are still investigating what cause the issue. Thank you for your patience.
Kind Regards,
Isidora Markovic
wpDataTables: FAQ | Facebook | Twitter | Front-end and back-end demo | Docs
Amelia: FAQ | Facebook | Twitter | Amelia demo sites | Docs
You can try our wpDataTables add-ons before purchase on these sandbox sites:
Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables
Very disappointing how long this has taken. I posted this 7 days ago.
Hi Robert,
Sorry for late response. Like I explain you in previous post last week we have national holiday and for weekends we are not working. There was some error with filters that contain % and we fix that you can check. If you still getting errors just clear the browser cache.
About the second issue that you have numbers in filter without thousands separator, I can confirm that is a bug on our side. This will be fixed for next update version.Thank you for reporting this.
Sorry for inconvenience,
Best regards
Kind Regards,
Isidora Markovic
wpDataTables: FAQ | Facebook | Twitter | Front-end and back-end demo | Docs
Amelia: FAQ | Facebook | Twitter | Amelia demo sites | Docs
You can try our wpDataTables add-ons before purchase on these sandbox sites:
Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables
Hi Milan - I understand that you had a holiday, but I still feel that these issues were disregarded too quickly.
a) I cannot see any change in the filters issue for this post - https://superguide.staging.wpengine.com/boost-your-superannuation/superguide-retirement-reckoner - i have cleared the cache and tried in incognito
b) When will the next update version with the fix for the thousands separate be available? I understand you cannot say exactly but roughly, will this be one day, one week, one month?
c) Regarding the issue where the prefix and suffix are not included in the filters, please can you explain the logic in this? And if you agree that this is an oversight and also needs to be fixed, when will this be in place?
Cheers, Rob
Hi Robert,
Issue was not disregarded, we was debugging code on your site which have some time to find what cause the issue.
a)Can you please check now? It was not applied on minified js files that are generated from original files. We turn this off and now is working.
b)Like you said I can't tell you exactly when it will be release, because it depends of implementing new features and testing plugin. We will try to be as soon as possible.
c)Whatever you enter in the “Cell content prefix” (E.g. $ sign, or other currency) will be rendered in each cell of this column before the actual cell value; whatever you enter in the “Cell content suffix” (E.g. “%” or “pcs.”) will be rendered after the actual cell value, and this will not affect sorting, filtering, or any other column functions.
So in filters will be populated with actual values of table without prefix and suffix. They are predicted for visual presentation only.
Kind Regards,
Isidora Markovic
wpDataTables: FAQ | Facebook | Twitter | Front-end and back-end demo | Docs
Amelia: FAQ | Facebook | Twitter | Amelia demo sites | Docs
You can try our wpDataTables add-ons before purchase on these sandbox sites:
Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables
Thanks Milan
a) Yes this works now
c) It still doesn't make sense to me why you would allow for suffixes and prefixes on cells but not also allow them on the filter.
Hi Robert,
Sorry for late response.
We are located in Serbia and our working time is from 10:00 to 17:00 CET. business days.
a) I am glad that tables is working fine.
b) I describe to you in previous post for what prefix and suffix are predicted. This feature is implement because a lot of customers request some addition information for integer or a float column. If the original data for integer or float column contain something else except the numbers, it will be became string column. With string column you can't use features like calculating totals, minimum, maximum and average values in WordPress Tables and also making formula columns.
Kind Regards,
Isidora Markovic
wpDataTables: FAQ | Facebook | Twitter | Front-end and back-end demo | Docs
Amelia: FAQ | Facebook | Twitter | Amelia demo sites | Docs
You can try our wpDataTables add-ons before purchase on these sandbox sites:
Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables