Hi!
I am currently trying to figure out if it is possible to have the task editor to have a countdown for the “duration format.”
Instead of:
Have it display something like
Time left: 5 minutes.
(I did figure out how to do it in the Ticket Lister with scripts, but not really useful right now, and well…technically in the Task Editor as well but it would require LOTS of sql.exec() calls, and updating the [Tasks].[Content]…and that is not ideal either)
[=FD(ADS('{TICKET DATE:yyyy-MM-dd HH:mm}',TN('{CUSTOM DATA TASK:Fulfillment Minutes}' * 60)),'yyyy-MM-dd HH:mm')]
to get fulfilment time but I can’t get TN() to work inside ADS()
You might be able to pass everything off to a script to calculate fulfilment time. For javascript use this time format for adding and subracting dates: yyyy-MM-ddTHH:mm:ss
Hmm I couldn’t even get the whole thing starting from the [= to work it just displays exactly what is typed, other than the <m:> which is replaced with the elapsed minutes…