Change Table color according ticket time status

V5 Question
3

You can color buttons depending on minutes by using Automation Scripts.

image.png2710×1745 274 KB

I created a script with fn handler.

image.png2710×1745 160 KB

function getColor(minutes){
  if(minutes > 60) 
    return 'red';
  if(minutes > 30)
    return 'coral';
  if(minutes > 15)
    return 'orange';
  return 'green';
}

… and updated State Format to call fn.getColor function to get color for specific minutes.

image.png2710×1745 174 KB

This is the state display format I’ve used. It both displays colors and minutes.

<background {CALL:fn.getColor('{ENTITY STATE MINUTES:Status}')}>$1<br/>{ENTITY STATE MINUTES:Status}</background>

For production use you can prefer to use this format to reduce database queries. It will only update button colors.

<background {CALL:fn.getColor('{ENTITY STATE MINUTES:Status}')}>$1</background>

If you need more info about formatting table buttons you can read this tutorial.

4 Likes