So wondering if anyone has come across this case. We have 2 data sets: one has thousands of locations with fields for status and assigned inspector, then another data set for inspector locations with a field for the max number each can handle. Trying to determine an approach to run a script which will take the first inspector and assign locations to each inspector up to their max. Once the first inspector is assigned their max, the next inspector assigned up to their max until all are assigned. Next time the script is run it will look at the first inspector, check to see how many locations are assigned and open then assign additional as needed, then through each inspector.
