Forum Discussion
ChayceDuncan2
5 years agoQrew Cadet
I've done something exactly like that in a similar situation and that solution is the one I employed. One thing to consider is that you probably want to re-sequence each day to reset the counts. Basically if Person 1 is just faster - and they do 10 more than person 2 each day - within a couple of days Person 2 is going to be pretty far behind.
An easy solution is to have a daily 'reset' almost - where you assign a number from 1 to n that lets you reset the assignments. So:
[Feedback Type]="Complaint" and
Mod(if( [Resequence #] > 0, [Resequence #],[Record ID#]),ToNumber([Number of people]) ) = 0,
if you've assigned a new Resequence # - use that number for your Mod calc, otherwise RID
ToUser("person1@companyemail.com")
Chayce Duncan | Director of Strategic Solutions
(720) 739-1406 | chayceduncan@quandarycg.com
Quandary Knowledge Base
An easy solution is to have a daily 'reset' almost - where you assign a number from 1 to n that lets you reset the assignments. So:
[Feedback Type]="Complaint" and
Mod(if( [Resequence #] > 0, [Resequence #],[Record ID#]),ToNumber([Number of people]) ) = 0,
if you've assigned a new Resequence # - use that number for your Mod calc, otherwise RID
ToUser("person1@companyemail.com")
Chayce Duncan | Director of Strategic Solutions
(720) 739-1406 | chayceduncan@quandarycg.com
Quandary Knowledge Base
- EvanBohan5 years agoQrew CadetOkay but if I only get one complaint every few days, wouldn't it always assign to the first person on the list?
- ChayceDuncan25 years agoQrew CadetIs is that infrequent that they come in? if they only come in every couple of days - you could get creative using automations - and instead of having a formula - let the automation pick for you. Basically you could have a set up where you log the most recent person who was assigned in some kind of assignments module, and then use automations to store the next person up into the assignment field for the complaint. The thinking behind the first solution and a formulaic approach works well when you have a lot of traffic and need to assign them quickly and in bulk
Chayce Duncan | Director of Strategic Solutions
(720) 739-1406 | chayceduncan@quandarycg.com
Quandary Knowledge Base