Forum Discussion

ZimilPatel's avatar
ZimilPatel
Qrew Member
6 years ago

How to calculate total time for which a field held a particular value

We have a ticketing system and to solve a ticket, we often need to gather additional information from the ticket opener and a TPA.  For each ticket, we log all activities (in a child table) in form of...
App builders
Ask about Quickbase functionality
Forms
QuickBaseCoachD's avatar
QuickBaseCoachD
Qrew Captain
6 years ago
Daniel is in the right track here. Consider using an �Automation� to do the two steps as you can be sure if the sequence they will fire in.

The trick will be to make a report link field which uniquely identifies which records to apply an end date to. Maybe the automation will allow editing all child records without an end date ( there should only be one).