Forum Discussion
MarkShnier__You
Qrew Legend
4 years agoIt's a problem you're having is that you have taken the shortcut of using a list use your field for the technicians. It would be far far easier to summarize the data if you list the technicians in the child table. That way they would be independent records and they would inherit the time of the job down to their records. That it would be a simple job to summarize the time per technician.
So my first suggestion is to change your entry method to have a trial table on the project of assigned technicians. This would be a Many to Many join table where one job has many assign technicians and where one technician is assigned to many jobs.
(having said that, there is new functionality coming "soon" (like this summer) with Formula Queries which is very mind blowing to us long time developers, so we have to re-think how we say you "have to " structure your app.
If however you are completely married to continuing to have the convenience of a list user field for the assigned technicians, then you will need to set up an automation or a pipeline to create and maintain those child tables tables automatically. We're building those automation or pipelines, I would trigger whenever the project records are being added or modified and when that field changes and the first step would be to delete all the assigned technicians and then rebuild them.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
So my first suggestion is to change your entry method to have a trial table on the project of assigned technicians. This would be a Many to Many join table where one job has many assign technicians and where one technician is assigned to many jobs.
(having said that, there is new functionality coming "soon" (like this summer) with Formula Queries which is very mind blowing to us long time developers, so we have to re-think how we say you "have to " structure your app.
If however you are completely married to continuing to have the convenience of a list user field for the assigned technicians, then you will need to set up an automation or a pipeline to create and maintain those child tables tables automatically. We're building those automation or pipelines, I would trigger whenever the project records are being added or modified and when that field changes and the first step would be to delete all the assigned technicians and then rebuild them.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
- JeffNixon4 years agoQrew MemberYea, reality is i need to create an employees table that feeds into the work orders. So, there is no way to do this...
------------------------------
Jeff Nixon
------------------------------