"Conditional formatting" (#3512305) / TMS-Plugins

Comments

Daniel Ochoa started the conversation
October 31, 2023 at 10:52pm
Hello dear TMSPlugins team,

I must start by commending your plugin for its flawless performance. Now, what I need to know and accomplish relates to Conditional Formatting. I require guidance on how to change the color of a cell or an entire row after a certain number of days have passed. For instance, I have a field named "Shipment Date" and another field named "Return Date." I need to set it up so that the "Return Date" turns red, or the entire row turns red if more than 5 days have passed from the "Shipment Date."

To illustrate, if the "Shipment Date" is October 31, and the "Return Date" is input as November 7, it should automatically turn red because more than 5 days have elapsed. How would I set or specify the number of days for this to trigger the red color?

Additionally, I would like to know if it's possible to turn it red, or another color, if the "Return Date" field remains empty for 5 or more days, serving as an alert. This is particularly important for my use case, as I utilize this for processing requests. In this table, all the information is recorded, and I want to have an alert system in place. If more than 5 days pass with the "Return Date" field empty, it indicates that the requests have not been received, and we need to follow up, or if it takes longer than 5 days to return. I would appreciate your guidance on how to achieve this.
I am attaching a screenshot of my table for your reference.

I want to express my gratitude in advance for your assistance
Sincerely, Daniel Ochoa R.
Attached files: tms-plugin-conditional.png
1,894
Miloš replied
November 7, 2023 at 6:36pm
Hi Daniel Ochoa R.

Firstly, I would like to sincerely apologize for the delayed response as we have been experiencing an unusually high number of tickets. I am sorry that it has taken longer than usual to respond to your concern and your patience is highly appreciated.

-

I am truly sorry to disappoint you, but at this time, we don't have any built-in solution to achieve this.

The main issue/limitation at the moment with our conditional Formatting is , we can only set it to be something like "if the current value is this" , such as equals, less than, higher than, or contains;

But you can only set a Conditional Rule to look at cells inside its own Column.

We can not set something like :

Look if Column B Date becomes 5 days later than Column B, or something like that.

In other words, we do not currently have a way to combine two or more Columns into a same condition, and that is why it's currently not possible with any built-in feature.

-

You can suggest it to our developers - they will do their best to make a solution in the future.

Please feel free to search on our suggestions page,

to see if someone may be already suggested this feature. If you can't see it, feel free to add your suggestion there, and as more people vote, the feature will move higher on the priority list.

You can certainly follow our changeLog page if you'd like ( it is also available in the plugin dashboard), where we state any changes/new features/bug fixes during updates;

and our newsletter , so you're informed about new features, bug fixes, freebies, etc.

-

If you have coding skills and wish to try to make a custom solution now,

you can check out our available hooks for Developers on this documentation and see if you can find any hook that might help.

Please be advised that custom solutions with hooks are not included in our support.

You can also research resources such as Stack Overflow to see if any other user perhaps found a workaround.

( We do like to give examples for certain solutions, but for this use-case, we, unfortunately, don't have anything yet)
Kind Regards,

Miloš Jovanović
[email protected]

Rate my support
Try our FREE mapping plugin! MapSVG - easy Google maps, interactive SVG maps and floor plans, choropleth maps and much more - https://wordpress.org/plugins/mapsvg-lite-interactive-vector-maps/

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