We're Moving to a New Support Platform – Starting June 1st!
We’re excited to let you know that starting June 1st, we’ll be transitioning to a new support system that will be available directly on our product websites – Amelia, wpDataTables, and Report Builder. In fact, the new support platform is already live for Amelia and wpDataTables, and we encourage you to reach out to us there.
You'll always be able to reach us through a widget in the bottom right corner of each website, where you can ask questions, report issues, or simply get assistance.
While we still do not offer live support, a new advanced, AI-powered assistant, trained on our documentation, use cases, and real conversations with our team, is there to help with basic to intermediate questions in no time.
We're doing our best to make this transition smooth and hassle-free. After June 1st, this current support website will redirect you to the new "Contact Us" pages on our product sites.
Thanks for your continued support and trust – we’re excited to bring you an even better support experience!
Hello,
I have a dataset uploaded into wpdatatables via an Excel spreadsheet. The data contains salaries by percentile, and I've been able to create some good tables and charts from the data.
What I'd also like to happen is for the user to be able to enter a number (a salary) into a search box, which would then query the wpdatatables data, and the user would then receive a result along the lines of 'Your salary is between the 80th and 90th percentile', for example.
Is there a way for users to query data uploaded into wpdatatables this way?
Thanks,
Andrew
Hello Andrew
I don't quite understand what the table displays. Could you provide me with at least some screenshots of the table, so I have an idea of what you're trying to do?
The global search finds the data entered in the search, so it cannot display anything "in-between", it can only display the search item you entered.
Kind Regards,
Aleksandar Vuković
aleksandar.vukovic@tmsproducts.io
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
Hi Aleksandar ,
Sure, I've attached a screenshot of the table.
So I'd like for a user to be able to enter their salary/age into a search box on the page, and for it to return in which percentile they lie. For example, if I entered a salary of £20,000 and an age of 35, the result would be that I'm between the 10th and 20th percentile.
Does that make sense?
This may require the use of a third party plugin to integrate with the uploaded data, and if that's the case, do you have any idea which plugin it'd be best to use?
Thanks,
Andrew
Hi Andrew
I understand what you're trying to do, but unfortunately, it can't be done.
As mentioned in my previous response, global search finds the data entered in the search, and it finds only that. So, if you were to enter "32", it would probably return a part of the price (for example, if you have 23,258, since it sees "32" in there), but it would not return the row where you have "30-39".
I am not aware of any plugins that would allow this to happen. None of the add-ons we have would, for sure. You can include filters, individually per column, but using the global search, it can't be done.
Kind Regards,
Aleksandar Vuković
aleksandar.vukovic@tmsproducts.io
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