Limit assignment of orders to one User

Question

HelloWe're creating an sales order dispositioning tool and we ran into a problem.&nbsp; We have a summary table with unassigned orders were multiple users can assign the same order to themselves. We would like to limit the dispositioning as the order is assigned to one user.Appreciate any suggestions to solve for this issue.------------------------------Juan Cardona Morales------------------------------

markshnier__you · Answer

I will have to think about this one. The only hope would be some trick with Custom Data Rules.------------------------------Mark Shnier (YQC)Quick Base Solution ProviderYour Quick Base Coachhttp://QuickBaseCoach.commark.shnier@gmail.com------------------------------

markshnier__you · Answer

I am trying to understand the issue. Presumably this is a report that only consists of unassigned orders. Are you saying that two different users could have the same report on their screen and both grab the same order?

------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------

juancardona_mor · Answer

Hi Mark, Correct. Both users will have the same report with the same unassigned orders. We're trying to see if there's way for them not to choose the same order at the same time.

------------------------------
Juan Cardona Morales
------------------------------

markshnier__you · Answer

How to they "choose" the record.&nbsp; Do they enter their name or userid into a field?------------------------------Mark Shnier (YQC)Quick Base Solution ProviderYour Quick Base Coachhttp://QuickBaseCoach.commark.shnier@gmail.com------------------------------

juancardona_mor · Answer

Using a button with the following codevar text addurl = URLRoot() &amp; "db/" &amp; Dbid() &amp; "?a=API_EditRecord" &amp; "&amp;rid=" &amp; [Record ID#] &amp; "&amp;AppToken=[APPtoken]" &amp; ToText(User());"&lt;a class=\"Vibrant Success\" style=\"width:310px; text-align: center;\" href='" &amp; $addurl &amp; "&amp;rdr=" &amp; URLEncode( URLRoot() &amp; "db/" &amp; Dbid() &amp; "?a=doredirect&amp;z=" &amp; Rurl()) &amp; "')&gt;Assign to Me&lt;/a&gt;"------------------------------Juan Cardona Morales------------------------------

Forum Discussion

Limit assignment of orders to one User

7 Replies