Assign Orders to a Shift
How to assign Orders to a Shift
with MS SQL
May 14, 2021
HyperC lets you solve optimal assignment for your Orders to a Shift with your data from MS SQL — no code required.
You have this ...
A list of Orders
with their parameters in MS SQL
A Calendar of Assignments
with parameters in MS SQL
automatically do this!
assign to a Shift
Automatically select optimal allocation in MS SQL table
Workflows with Orders
MS SQL workflows
How assigning Orders to a Shift with MS SQL Works
Step 1: Add MS SQL as database connection.30 seconds
Step 2: Create a business rule to take Orders from MS SQL and put to a Shift table in MS SQL.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 MS SQL (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!