Hey everyone!
With the Labour Day holidays coming up, we’d like to let you know about our upcoming working hours:
Thursday, May 1st: Our team will be off during Labour Day.
Friday, May 2nd: We'll also be off for an extended holiday break.
We’ll be back on Monday, May 5th, ready to respond to all messages received during this time.
In the meantime, if you need help, feel free to:
-
Use the support widget on the bottom right of our websites (Amelia and wpDataTables) — our AI-powered assistant is available 24/7 and can help with many common questions.
-
Visit our documentation, articles, or YouTube channels for quick answers and step-by-step guides.
https://www.youtube.com/@AmeliaWordPressBookingPlugin/videos
https://www.youtube.com/@wpDataTables/videos
Thank you for being so understanding, and we hope you enjoy the long weekend!
Hi - Is there a date range filter option to only show rows that have TODAY'S date? This would be so this could auto-update each day. Also, how would the responsiveness work if different days the table displays different numbers of rows?
Thanks!
Hi Dave
Thank you for reaching out to us.
You can use a placeholder to filter the results that match today's date, by adding this placeholder in the column's settings, filtering tab %CURRENT_DATE%
The responsiveness function will still act the same and displayed the filtered results.
Do let us know if you need any further assistance.
Thanks! I suppose I should have been more specific. Can I have it match not to the full date but just month and day, ignoring year? I can have a column that shows month and day like MM/DD in my dataset, but can I have it only show rows that have a MM/DD equal to today's MM/DD?
And also - can I hide all filter controls from the published site?
Hi Dave
To be honest, I don't think this is possible, not with the plugin's builtin features at least, but I have forwarded it to our developers to take a look. If they have an example of a custom solution I will forward it straight over to you.
When it comes to hiding the filters you can simply disable the Advanced column filters option from the Sorting and filtering tab in the table settings.
Hi Dave
Here are a few suggestions you can try regarding the table's dynamic filter:
You can create an SQL query like this
Like this only rows with current date will be shown .
You can also filter the table with Conditional formatting for that column where is available %TODAY% placeholder. You have to set rules like this where you will set two rules one that is less than %TODAY% and second that is greater than %TODAY% and set row class for example hide(like in the example)
Then you have to make that class in Custom wpDataTables CSS under the "Custom JS AND CSS" in the main settings of wpdatatables.
I hope this helps, do let me know if you need any further assistance.