Hey everyone!

With the holiday season upon us, we want to share our upcoming working hours:

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

Okay
  Public Ticket #3512305
Conditional formatting
Closed

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,847
    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