SharePoint 2010 多个用户访问同一列表问题
我们有一个包含 1000 多个电话号码的列表。该列表按截止日期和其他标准按特定顺序排序。这个顺序非常重要，需要在解决方案中维护。
我们有一组呼叫者（大约 4 个），他们将按照号码排序的顺序呼叫此列表中的号码。这些呼叫者将通过 InfoPath 表单一次显示一个列表项，一旦他们发出呼叫，他们将更新列表项并显示排序顺序规定的下一个列表项。
问题是：如果有 1 个呼叫者，这会很容易，但是如果有 4 个呼叫者，我们不希望他们多次呼叫同一个人。因此，他们需要从堆顶部抓取下一个尚未被其他调用者获取的列表项。
有没有办法构建一个 Web 部件（不幸的是，没有 Visual Studio），一旦加载就会找到第一个未分配的列表项并将其分配给当前用户？
当然，我们可以通过让管理员在数据表视图中通过大量复制/粘贴来分配每天的所有呼叫来手动完成整个事情，但自动会更好。
我要提到的是，我没有 Visual Studio，所以我在这里没有这个选项。但我确实有 SharePoint 2010、SharePoint Designer 2010 和 InfoPath 2010。
我希望这是有意义的，任何想法、想法和方法都将不胜感激，因为我已经用完了！谢谢！！！！！
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.
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.
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.
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.
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!!!!!
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（5）
您可以使用 Visual Studio Express 开发 SharePoint Web 部件，但这有点困难，因为您错过了一些使您的生活更轻松的工具，例如 WSPBuilder 等。
SO - 使用 Visual Studio 2010 Express 构建 Web 部件
另一种选择是使用 javascript 客户端访问 SharePoint Web通过 SPService 提供服务 - 那么只需要记事本即可。
不过，在这两种方法中，你实际上是在使用扳手作为锤子，所以我不得不说 - 你有多重视你的时间？ ;)
You can develop SharePoint web parts using Visual Studio Express, but its a bit harder as you miss some of the tools that make your life easier like WSPBuilder etc.
SO - Building webparts with Visual Studio 2010 Express
Another alternative would be to use javascript client side to access SharePoints Web Services via SPService - then nothing more than notepad is required.
You're really using a wrench as a hammer with either of these approaches though, so I've got to say - how much do you value your time at? ;)
我可以提供一个非常健壮的选择；假设所有项目都是零碎添加的（不是在同一秒内）。您可以使用以下公式添加计算列以在添加时随机分配每个项目：
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:
我建议分配给 listItem 的编辑的工作流程；当调用者在调用工作流程完成后编辑其额外字段（如“Operating(bool)”）时；该项目以某种方式被禁用。
唯一的开销是调用者每次都需要编辑该项目。
但最简单的部分是列表查看器 Web 部件 (oob) 可以仅与默认视图设置一起使用，例如“操作”字段仅为“假”。
I suggest a workflow that is assigned to listItem's edit; that when a caller edits its extra field like "Operating(bool)" after the calling workflow completes; the item is disabled somehow.
Only overhead of this is a caller needs to edit the item every time.
But the easy part is a listviewer webpart (oob) can be used just with a default view setting like "Operating" field is "false" only.
这很简单。加载表单时，指示表单将状态字段更新为（假设为“已分配”）并自动重新提交表单。提取下一个要呼叫的号码的信息路径列表需要排除任何处于已分配状态的号码。您还需要在每次调用获取下一个可用数据之前重新查询数据连接以刷新列表。调用者完成后，他们可以单击提交表单、清除状态字段并关闭表单的按钮。
This is simple. On form load, instruct the form to update a status field to (let's say 'assigned') and automatically resubmit the form back. Your infopath list that pulls in the next number to call would need to exclude any that are in the assigned status. You'd also need to re-query your data connection to refresh the list each time before a call is made to grab the next available. Once the caller is finished, they can click a button that submits the form, clears the status field and closes the form.
您还可以使用辅助数据连接将活动项目拉入信息路径表单。有一种方法可以使用在表单字段中插入超链接，并使任何字段成为直接指向单个项目的 URL 超链接。尽管您必须将 URL 保存在创建项目的表单字段中。这很容易做到，您只需将 URL 与表单名称进行连接即可。
Yo can also pull in the active items into an infopath form using a secondary data connection. There is a way to use the insert hyperlink into the form field, and make any of your fields a URL hyperlink directly to the individual item. Although you'd have to have the URL epsaved in a field in the form the item was created in. That's easy to do, you can just con at the URL with the form name.