I've gotten a request to create a custom object with a certain custom field called "priority". Users may self rank this "priority" field(1-10, 1 being most urgent). I would then like to show (perhaps in an embedded report) where their request stands in the queue, so to speak. The catch is, we can't have two requests in the #1 position, or any other position. If someone submits a request as a #1 priority, and we already have a #1, the existing #1 gets pushed to position #2. And so on for all the other requests in the queue.
Hope that makes sense.
3 risposte
so if you have three users submit a Priority 1 request - which one would you action first? Do you work the requests based on priority and then order received?
