SharePoint表单提交到DB [英] SharePoint form submission to DB

问题描述

我有各种各样的office 365共享点表单，在提交时启动了在sharepoint设计器中创建的工作流程。这些表单遵循批准过程，并根据表单内的下拉列表的状态触发电子邮件。在工作流程结束时，我希望将该表单提交给外部数据库。如何完成。

解决方案

添加一小段javascript（最简单的jQuery）。收集数据并调用Web服务以保存到外部数据库。



在Sharepoint 2013中，您可以创建直接链接到数据库的外部内容类型。然后使用CSOM以任何其他列表的形式访问它。



最后，你可以做事件接收器拦截提交并做你需要的任何自定义操作。

I have a variety of sharepoint forms for office 365 that upon submission kick off a workflow created in sharepoint designer. These forms follow an approval process and trigger emails based on statuses of a drop down list inside the form. At the conclusion of the workflow i would like to have that form submit to a external database. How would this be completed.

解决方案

Add small piece of javascript (easiest with jQuery). Collect the data and call web service to save to external database.

In Sharepoint 2013, you can create external content type that links directly to the database. Then use CSOM to access it as any other list.

Finally, you could do event receiver that will intercept the submit and do whatever custom action you need.

这篇关于SharePoint表单提交到DB的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！