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.
  • MCFNeil's avatar
    MCFNeil
    Qrew Captain
    9 years ago
    Oh... I did it the other day in 30 min... 100% native.  no need for limiting snapshots, and zero form rules...
  • _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.
  • MCFNeil's avatar
    MCFNeil
    Qrew Captain
    9 years ago
    and "zero" reverse relationships I should add.
  • QuickBaseCoachD's avatar
    QuickBaseCoachD
    Qrew Captain
    9 years ago
    Matthew, good trick if you can do this natively and without snapshots. _
  • QuickBaseCoachD's avatar
    QuickBaseCoachD
    Qrew Captain
    8 years ago
    I could demo my method if you contact me via my website. QuickBaseCoach.com