A while ago I built a minimalist SLA grid formatter for a team that needed to see their SLAs at a glance. They wanted their SLAs at the very top of their task form, so a formatter was about the only way to satisfy their requirement. I think it turned out great so I’d like to share it with you.
It’s easy to build, so let’s get started. Create a new UI Macro [sys_ui_macro]:
Then create a new Formatter [sys_ui_formatter] that uses the new macro:
It really shouldn’t matter what table you choose, this should work with any table extended off Task (only task tables can have SLAs attached). In fact, you could just choose Task to make this formatter available on all task table form layouts.
The last step is to customize the form layout for your table to add the SLA Grid formatter anywhere you like. Easy peasy!
In my use case the SLAs were five-day and thirty-day SLAs. If yours are much shorter and you’d rather display hours instead of days, it shouldn’t be too much work to tweak the script, but I leave that as an exercise for the reader. Enjoy!