Forum Discussion

RebeccahDemaray's avatar
RebeccahDemaray
Qrew Member
9 years ago

Report to show duration between each status change

I set up notifications to go to a GMail account for any changes to a "Status" field (multiple choice). I then made a new table title "Edit Log" and linked it to the GMail data. Within this table, I ...
QuickBaseCoachD's avatar
QuickBaseCoachD
Qrew Captain
9 years ago
... but its still difficult to calculate the duration between status updates even with a child table.  Might be possible with summary fields to get the Date time of the last status change update  and then snapshots, but it would take some messing around to get that working.
_anomDiebolt_'s avatar
_anomDiebolt_
Qrew Elite
9 years ago
MS> its still difficult ...

Here is my advice: If you have more than one summary and lookup field included in your formula you should be using script for the entire solution. Mark may relax the one to some other number (say a milliion) but the larger the number the more pain there is in writing and maintaining the formula and extra fields required.