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