Hi,

I’m trying to add a column to a table in my low code app that counts down in real time.

I have a column of a datetime of a TAKE and a column with a duration and I want to count down until the TAKE + duration is <= Now.

My solution so far has been to create a custom GQI Operator called “Time left” and it looks like this:

public void HandleRow(GQIEditableRow row)
{
var timeOfLastTake = row.GetValue<DateTime>(_timeOfLastTakeColumn).ToLocalTime();
var timeOfLastStop = row.GetValue<DateTime>(_timeOfLastStopColumn).ToLocalTime();
var duration = row.GetValue<Double>(_durationColumn);
TimeSpan timeLeft = timeOfLastTake.AddSeconds(duration).Subtract(DateTime.Now);

if (timeLeft <= TimeSpan.Zero || timeOfLastStop >= timeOfLastTake)
row.SetValue(_timeLeftColumn, TimeSpan.Zero);
else
row.SetValue(_timeLeftColumn, timeLeft);
}

The problem is that the low code app GUI doesn’t refresh regularly enough. So I added a Trigger feed, set it to the lowest possible value of 5 seconds and connected it to the table and that kind of works but looks very janky and is not accurate enough.

Is there a better way to get a real time count down timer as a column in a low code app?