Forum Discussion
QuickBaseCoachD
8 years agoQrew Captain
.. just chiming into this thread here. I have to do this for a client and it was "non trivial".
I had to make a child table for the Status change records and each one had start and stop date time fields. To change status, the user would click a button on ghe parent help ticket which would update the most recent status record to "stop it" with the date/time of now(), and then add a new child status record and "start it" it now().
Then the actual status for the main help ticket record was a reverse lookup from the most recent child record.
Then I could make summary fields on the help ticket for the total time spent in each stataus.
I had to make a child table for the Status change records and each one had start and stop date time fields. To change status, the user would click a button on ghe parent help ticket which would update the most recent status record to "stop it" with the date/time of now(), and then add a new child status record and "start it" it now().
Then the actual status for the main help ticket record was a reverse lookup from the most recent child record.
Then I could make summary fields on the help ticket for the total time spent in each stataus.
QuickBaseCoachD
8 years agoQrew Captain
There are Quick Base Solution Providers like Matthew and myself among other organization which do Quick Base training.
I guess that you can wait for Matthew to do his write up.
You will need to learn about how to set up Relationships.
There is the Quick base university as a resource centre to watch the videos. https://university.quickbase.com/
This forum is a great resource for any specific questions.
I guess that you can wait for Matthew to do his write up.
You will need to learn about how to set up Relationships.
There is the Quick base university as a resource centre to watch the videos. https://university.quickbase.com/
This forum is a great resource for any specific questions.