I have a list of 4 employees who visit various sites in the course of a week.
- Each week I want the system to automatically send each employee a form that they populate for each day of the week with fields - date, time start, time finish, site.
- Employee Name: Abby
- 6 June 2022 , 09h00, 10h00, Site ABC
- 6 June 2022, 10h30, 11h00, Site BCD
- 7 June 2022, 15h00, 15h30, Site XYZ
- Employee Name: John
- 6 June 2022 , 11h00, 12h00, Site ABC
- 7June 2022, 10h30, 11h00, Site JBD
- 8 June 2022, 08h00, 17h30, Site CPT
This form is then used to populate a scheduling smartsheet that I can filter (based on employee name or date) or site and from which I can draw reports for dashboards.
Suggestions on how best to do this would be appreciated.