This base uses a large number of linked record fields, lookups and rollups, formulas, and a filtered view to assign requests submitted via form to agents in a round-robin style.
It does this by determining which agents have the least number of open requests. If there are multiple agents with the lowest number of open requests, formula fields will determine the next agent to be assigned a request based on their auto-generated ID number.
On the client's end, this results in the following behavior while filling out a form: each time the form is submitted, only one choice will show up when they choose an option for 'Assigned agent:'.
The key to this functionality is the control table. Each agent needs to be linked to the single record contained in the control table -- otherwise the base's functionality will be broken. I've incorporated an alert which will display if this link is not established 👍
This table has the logic built in to: