We're Moving to a New Support Platform – Starting June 1st!

We’re excited to let you know that starting June 1st, we’ll be transitioning to a new support system that will be available directly on our product websites – Amelia, wpDataTables, and Report Builder. In fact, the new support platform is already live for Amelia and wpDataTables, and we encourage you to reach out to us there.

You'll always be able to reach us through a widget in the bottom right corner of each website, where you can ask questions, report issues, or simply get assistance.

While we still do not offer live support, a new advanced, AI-powered assistant, trained on our documentation, use cases, and real conversations with our team, is there to help with basic to intermediate questions in no time.

We're doing our best to make this transition smooth and hassle-free. After June 1st, this current support website will redirect you to the new "Contact Us" pages on our product sites.

Thanks for your continued support and trust – we’re excited to bring you an even better support experience!

Okay
  Public Ticket #2346548
Conditional Formatting
Closed

Comments

  • Dalton started the conversation
    April 1, 2020 at 9:26pm

    Just had a quick question about user based conditional formatting. In my WordPress site, if you boil it down, it is pretty much based on 2 things. "Users" and "Tanks". The purpose of this site is so that our customers can go through through and look at the current status of each of their tanks, which is being pulled into WPDataTables through a JSON feed. Depending on how full each Tank is, it will read "High", "Normal", "Low", or "Critical". This helps the user to easily sort by the Tanks requiring the most immediate attention. Currently, I have it setup to change the cell color based on a default value. Which is a good start. What I need to be able to do though, is set that default value to change depending on what user is logged in. Lets say "UserA" has a 10 gallon tank, while "UserB" has a 1000 gallon tank. Obviously these 2 users are going to have different preferences for how low their "Low" setting actually is. So essentially, I would like to be able to put a WordPress shortcode into the number field of the picture I will attach. I imagine the pseudocode would look something like this:

    • If cell value < myCriticalSetting : Set Cell Color To Red
    • If cell value < myLowSetting : Set Cell Color To Yellow

     and so on... Thanks in advance,


    - Dalton

  •  2,576
    Aleksandar replied
    April 2, 2020 at 12:35pm

    Hi Dalton

    If I understood you correctly, each user would have a different value of "High", "Normal", "Low" and "Critical". That needs to be entered manually in the table, and there can't be a condition between cells, that would differentiate between users. Meaning, you can't add a rule for a column if it overrides another rule:

    5979015121.png

    For example, if these two both had the same sign "<", one would override the other one, and there's no way to have multiple rules for multiple users.

    You would need to have a different table for each tank size. The data can be different for every logged-in user, if you enable Users see and edit only own data, so you could narrow it down, not having to create a table for each user. Unfortunately, I don't see another workaround for this.

    Maybe you can explore some workarounds on MySQL query side. If you can find a solution in that way, then you would be able to do it.

    Kind Regards, 

    Aleksandar Vuković
    [email protected]

    Rate my support

    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