Hi Guys,
I have a table component and I have a date/time field that the output fomat is set as stop watch. I would like to set a display rule based on the value as it changes. Basically if it goes over 45 min red, 30 to 44 yellow. anything below green. I havent figured out how to accomplish this. MAy I can use Java scriptting with some CSS but I dont know enough to take that approach.
Any help will be greatly appreciated.
Thank you
1 Like
Hi @remedina18
To achieve this, you can use display rules within your table component to change the text color based on the stopwatch value. Here’s how:
- Open the Table Component and go to the date/time field settings.
- Access the Field Editor and navigate to the “Display Rule” tab.
- Add Display Rules:
- Red (Over 45 min) → Condition:
> 45 min
, Action: Change text color to red.
- Yellow (30-44 min) → Condition:
30-44 min
, Action: Change text color to yellow.
- Green (Below 30 min) → Condition:
< 30 min
, Action: Change text color to green.
- Save the Rules, and they will automatically apply as the stopwatch value updates.
This eliminates the need for JavaScript or CSS since Tadabase display rules handle it efficiently.
For more details, check the Tadabase Display Rules Documentation.
Hi Chiper,
I looked at your recommendation but the date/time field doesnt have the options for greater than it only has options for before, after, during etc and the lowest time frame i can select for any of thoose is day.
Unless i’m looking in the wrong place.
Thank you