Adding records to details table automatically
Hello,
I am looking for help to fill "blanks" in appointment schedule for mobile workers. Blanks are non chargeable activities (mostly driving between sites).
Structure of the app is Clients (master table)<Assignments (detail table)
Assignments are scheduled by the office so each worker has a list of daily appointments on their smart phones. Assignments are NOT calendar/date records, they are records with several fields. Workers' daily schedules are reports of Assignment table ordered in expected start time.
After an assignment is completed, workers record time it has taken and add notes of what was done, so it becomes a "time sheet" for calculating working hours.
In order to complete time sheet record for each day, workers have to manually add driving and shopping "assignments" between customer visits, which takes time.
Is there a way to have a button that would add record to fill gap between assignments? Or have a way to calculate workday between start of the first job and end of the last one; the difference between length of workday and chargeable time would be non-chargeable work.
I would be grateful for any pointers.
------------------------------
Arkady
------------------------------
I am looking for help to fill "blanks" in appointment schedule for mobile workers. Blanks are non chargeable activities (mostly driving between sites).
Structure of the app is Clients (master table)<Assignments (detail table)
Assignments are scheduled by the office so each worker has a list of daily appointments on their smart phones. Assignments are NOT calendar/date records, they are records with several fields. Workers' daily schedules are reports of Assignment table ordered in expected start time.
After an assignment is completed, workers record time it has taken and add notes of what was done, so it becomes a "time sheet" for calculating working hours.
In order to complete time sheet record for each day, workers have to manually add driving and shopping "assignments" between customer visits, which takes time.
Is there a way to have a button that would add record to fill gap between assignments? Or have a way to calculate workday between start of the first job and end of the last one; the difference between length of workday and chargeable time would be non-chargeable work.
I would be grateful for any pointers.
------------------------------
Arkady
------------------------------
