SharePoint 2010多个用户访问同一列表问题 [英] SharePoint 2010 multiple users accessing same list issue

问题描述

我们有一个包含1000多个电话号码的列表.该列表按到期日和其他条件以特定顺序排序.此顺序非常重要，需要在解决方案中进行维护.

We have a list with 1000+ phone numbers in it. This list is sorted in a specific order by due dates and other criteria. This order is very important and needs to be maintained in the solution.

我们有一组呼叫者(大约4个)，它们将按照其排序顺序呼叫此列表中的号码.这些呼叫者将通过InfoPath表单一次显示一个列表项，一旦他们打电话，他们将更新该列表项，并显示由排序顺序决定的下一个列表项.

We have a group of callers (roughly 4) that will be calling the numbers in this list in the order they are sorted by. These callers are to be presented with one list item at a time, via an InfoPath form, and once they make the call they will update the list item and be presented with the next list item dictated by the sort order.

这里是问题:1个呼叫者非常容易，但是4个呼叫者我们不希望他们多次呼叫同一个人.因此，他们需要从其他呼叫者那里抢走另一个列表项，而这是另一个呼叫者尚未采取的.

Here's the problem: This would be very easy with 1 caller but with 4 callers we don't want them calling the same people more than once. So they need grab the next list item off the top of the pile that isn't already taken by another caller.

是否有一种构建Web部件的方法(不幸的是，请记住没有使用Visual Studio)，该Web部件一旦加载就会找到未分配的第一个列表项并将其分配给当前用户?

Is there a way to build a webpart (remember without Visual Studio unfortunately) that as soon as it loads would find the first list item that is unassigned and assign it to the current user?

我们当然可以手动完成全部操作，方法是让管理员每天在数据表视图中为所有呼叫分配大量副本/粘贴，但自动会好得多.

We could accomplish this whole thing manually of course by having an admin assign all the calls each day with a large copy/paste in Datasheet View but automatic would be soooo much better.

我会提到我没有Visual Studio，所以这里没有这个选项.但是我确实有SharePoint 2010，SharePoint Designer 2010和InfoPath 2010.

I will mention that I DO NOT have Visual Studio so I don't have that as an option here. But I do have SharePoint 2010, SharePoint Designer 2010, and InfoPath 2010.

我希望这是有道理的，自从我精疲力尽以来，任何想法，想法和方法将不胜感激！谢谢!!!!!

I hope this makes sense and any ideas, thoughts, approaches would be greatly appreciated since I've run out! Thanks!!!!!

推荐答案

我可以提供一个非常笨拙的选择；假设所有项目都是零散添加的(不是在同一秒内).您可以使用以下公式添加一个计算列，以在添加时随机分配每个项目:

I can offer a very bodgy alternative; presuming all the items are added piecemeal (not in the same second). You could add a calculated column to assign each item at random on addition, using the following formula:

CHOOSE(MOD(SECOND([Created]),4)+1,"Operator1","Operator2","Operator3","Operator4")

这篇关于SharePoint 2010多个用户访问同一列表问题的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！