I would like to know if it's possible to filter rows by the current (today's) date. I want to purchase but need to know before I buy. The only answer I found is to use SQL, but I find it hard to believe that a plugin with so many features can't filter and display entries by today's date using csv or excel format. Thanks in advance for your answer!
Unfortunately there is no specific feature for filtering table by today's date but there is a workaround. In conditional formatting you can set the class to the rows that are not today's date by using placeholder %TODAY%. After that in custom CSS you just set display: none to the rows with that class and they will not be shown in the table. Another way is using MySQL as you mentioned.
You can try our sandbox site: Front-end & Back-end - you can find a fully functional version there to try out all plugin features.
I really want to make this work and purchase your product, but I must admit that I understand nothing about coding and custom css and classes. I went to my date column and set conditional formatting to "set row css class" to %TODAY%. I left the line after "if cell value" empty, since a calendar pops up. Is this correct so far?
Then I went to DISPLAY and CSS classes and entered display: none, but I'm sure I'm missing something since I know nothing about setting classes. Is there any chance you could help with a little more detail? Maybe a screenshot if possible of exactly what to enter? I really want to buy your product since it does everything else I need!
If you have purchased the plugin, please open a ticket in wpDataTables category with your purchase key and one of our developers will provide you help with that.
Thank you Milos! But when I try to set to %TODAY% it keeps reverting back to today's actual date, and it doesn't work (see attachment). I put the below code in my style.css file in my theme's child theme.
I would like to know if it's possible to filter rows by the current (today's) date. I want to purchase but need to know before I buy. The only answer I found is to use SQL, but I find it hard to believe that a plugin with so many features can't filter and display entries by today's date using csv or excel format. Thanks in advance for your answer!
Hi ROB,
Thank you for the inquiry.
Unfortunately there is no specific feature for filtering table by today's date but there is a workaround. In conditional formatting you can set the class to the rows that are not today's date by using placeholder %TODAY%. After that in custom CSS you just set display: none to the rows with that class and they will not be shown in the table. Another way is using MySQL as you mentioned.
You can try our sandbox site: Front-end & Back-end - you can find a fully functional version there to try out all plugin features.
Hi Milos!
I really want to make this work and purchase your product, but I must admit that I understand nothing about coding and custom css and classes. I went to my date column and set conditional formatting to "set row css class" to %TODAY%. I left the line after "if cell value" empty, since a calendar pops up. Is this correct so far?
Then I went to DISPLAY and CSS classes and entered display: none, but I'm sure I'm missing something since I know nothing about setting classes. Is there any chance you could help with a little more detail? Maybe a screenshot if possible of exactly what to enter? I really want to buy your product since it does everything else I need!
Thank you Milos!
Hi ROB,
If you have purchased the plugin, please open a ticket in wpDataTables category with your purchase key and one of our developers will provide you help with that.
I have not purchased yet, I wanted to test it before I bought it. Do I need to purchase first to get this answered? Thanks...
Hi ROB,
No, sorry for misunderstanding. I thought that you brought the plugin so I redirect you to customer support to help you with the issue.
You should set like on the image from the attachment and then in CSS add this CSS rule:
.something { display: none; }Thank you Milos! But when I try to set to %TODAY% it keeps reverting back to today's actual date, and it doesn't work (see attachment). I put the below code in my style.css file in my theme's child theme.
.something { display: none; }
Milos... I figured out where to put the custom css, your workaround works! Do you get any credit for a purchase or are you the owner? :)