I have looked at different quickbase community forms but have not been able to figure out how to create a snapshot of the date and time.
I have a form that is used for tracking escalations when contacted by the field.
I want to be able to capture the date/time one of our representative opens the escalation form (to capture the average time it takes from Create to First Response)
and when the escalation is closed out (To capture average time it takes to resolve an escalation)
The problem is the time keeps is based on the status of the case and can change depending on where they are with the resolution or for example providing additional details that were forgotten after the record has been closed out.
Can you help with this?