Hey everyone!
With the holiday season upon us, we want to share our upcoming working hours:
- New Year: Our team will be off on January 1st and 2nd. We’ll be back on Friday, January 3rd, to respond to any messages received during this time.
- Weekend: As usual, we don’t work on weekends, so January 4th and 5th will also be non-working days.
- Orthodox Christmas: Our office will be closed on Monday and Tuesday, January 6th and 7th for the holiday.
After that, we’ll return to our regular schedule and assist you as quickly as possible.
In the meantime, you can explore our documentation for Amelia and wpDataTables. You'll find tons of helpful resources, including articles and handy video tutorials on YouTube (Amelia's YouTube Channel and wpDataTables' YouTube Channel), which might just have the answers you need while we’re away.
Thanks a bunch for your understanding and support!
Warm regards and happy holidays!
TMS
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.