Thank you for your videos. You're doing great work. I'm trying to build a dispatch board that shows technicians on the far left column and then every hour of the day as the other columns and when an appointment is booked for a customer and assigned to this technician a block appears in this table across the time duration you've set up according to job type you selected. This will also need to have dynamic conditions that tracks time and job status. Say the technician has arrived on the job, the block will change colors, or if the technician is late. It would also need to track the time total spent dispatched, arrived and working on the job. I'm not sure where to start with this.. maybe the new tables workflow?
Thank you for your videos. You're doing great work. I'm trying to build a dispatch board that shows technicians on the far left column and then every hour of the day as the other columns and when an appointment is booked for a customer and assigned to this technician a block appears in this table across the time duration you've set up according to job type you selected. This will also need to have dynamic conditions that tracks time and job status. Say the technician has arrived on the job, the block will change colors, or if the technician is late. It would also need to track the time total spent dispatched, arrived and working on the job. I'm not sure where to start with this.. maybe the new tables workflow?