Holiday Notice – Support Unavailable on April 18 and April 21
We just wanted to let you know that our support team will be offline on Friday, April 18th (Good Friday) and Monday, April 21st (Easter Monday) due to the holidays.
We'll be back on Tuesday, ready to assist you!
In the meantime, if you need any help, feel free to:
-
Use the support widget in the bottom right corner on our websites (Amelia and wpDataTables) — our latest AI-powered assistant is there 24/7 to help with basic and intermediate questions,
-
Browse our detailed documentation (Amelia, wpDataTables)
-
Explore helpful articles,
-
Or check out our YouTube channels for video guides!
Amelia YouTube Channel
wpDataTables YouTube Channel
Thank you for your understanding, and we wish you a wonderful holiday weekend!
Dear Sirs,
I have a database that contains a date field. Would it be possible to only display the data from that database where the date field is after todays current date? In other words display all content whose date is in the future. Likewise I then need a separate table of the same data displaying the data from all dates that are in the past. (A sort of archive system.)
Thank you for your patience with me.
Kind regards,
Ian
Hi Ian,
Thank you for your purchase.
Correct me if I am wrong, you want to hide all rows that contain date that is in the past compared euth the current date? If that is true you can use Conditional formatting and placeholder TODAY.
When you set that If cell value is less than current date(%TODAY% placeholder) then Set row CSS class for example hide_rows.(attachment 1)
Then you have to make that class in Custom wpDataTables CSS under the "Custom JS AND CSS" in main settings of wpdatatables like this(attachment 2):
.hide_rows{ display:none !important; }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
Milan,
That is exactly what I was asking for. I will now be able to create two tables one showing all data that is "old" (past today's date) and one showing "new" data showing all data that is still yet to arrive.
On a similar subject, my client would also like to show when new data has been added to the table. Is there any way to in effect show a row colour for 7 days to indicate that any new item added to the table is shown as "New" for 7 days. My thoughts are along the lines of setting up two rules, one to start the period using %TODAY% and the second to end the period using %TODAY% + 7 .
Is this possible?
Kind regards,
Ian
After the update now on new version the do not allow duplicate values option is missing. It was nice on older version I had used that option so people do not end up creating duplicate records but in new version I am unable to do that and people are end up creating duplicate values which is causing a huge problem
Hi Ian,
Unfortunately at the moment there’s no built-in solution. However it appears in requests from time to time so we will add to our idea list and look into some possible solutions on plugin side for one of next versions.
Hi Josh,
Can you please open a new ticket and we help you because the issues are different and we want to keep one issue related with the title of the ticket, so other customers can find it easily and also for every new post it will be sent notification to the customer who open this ticket that is not appropriate.
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