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