Automatically
Assign Surveyor to a Shift
How to assign Surveyor to a Shift with Google Sheets
June 30, 2020
HyperC lets you solve optimal assignment for your Surveyor to a Shift with your data from Google Sheets — no code required.
You have this ...
A list of Surveyors
with their parameters in Google Sheets
A Calendar of Assignments
with parameters in Google Sheets
automatically do this!
assign to a Shift
Automatically select optimal allocation in Google Sheets table
Workflows with Surveyor
Shift workflows
Google Sheets workflows
How assigning Surveyor to a Shift with Google Sheets Works
-
Step 1: Add Google Sheets as database connection.30 seconds
-
Step 2: Create a business rule to take Surveyor from Google Sheets and put to a Shift table in Google Sheets.10 minutes
- Create more rules as needed, like completing an order by an employee.
-
Step 3: Create a goal rule with a check that all required actions are completed (like all orders are satisfied).1 minute
-
Step 4: Click “Create a new Process” to connect your data from Google Sheets (and/or other sources) with rules you just wrote.15 seconds
-
That’s it! You just saved most of the management work and optimized the process!
