使用计算列和& ;;触发SharePoint列表工作流程让它每天都重演。 [英] Triggering a SharePoint list workflow using a calculated column & make it recurring everyday.
问题描述
嗨大家好，
我创建了一个SharePoint列表，其中包含多个字段，包括到期日期（日期/时间字段）和用于存储今日日期的字段今天（）公式。对于列表表单，我使用了InfoPath 2013.
$
工作流程应根据另一个名为no NoOfDays的计算列向我的收件箱和其他几个用户发送电子邮件警报。
NoOfDays =到期日 - 今天
如果NoOFDays = 30，则电子邮件应触发&我已完成该部分，并且我正确收到警报。
在SharePoint列表中创建项目后，将触发工作流。
但是我想每天12.00午夜运行这个工作流程，以检查满足上述标准的所有项目（NoOfDays = 30）。
我该怎么做？为了每天12.00午夜迭代工作流程我应该采取什么行动，条件？
请帮助我。
Hi Guys,
I have created a SharePoint list that has several fields including an expiration date (date/time field) and a field for storing Today date using today() formula. For the list form I have used InfoPath 2013.
The workflow should send an email alert to my inbox and to several other users based on another calculated column called no NoOfDays.
NoOfDays = Expiration Date - Today
If NoOFDays = 30 then the email should trigger & I have completed that part and I'm getting alerts correctly.
The workflow will trigger once an item is created in the SharePoint list.
But I want to run this workflow every day 12.00 mid-night in order to check all the items that are satisfying the above mentioned criteria (NoOfDays = 30).
How can I do that? What actions, conditions I should implement in order to iterate the workflow everyday 12.00 mid-night?
Please help me.
推荐答案
嗨Chiranthaka，这在几个方面是可行的。开箱即用的方式是：
Hi Chiranthaka, this is do-able in several ways. The out of the box way is here:
https://sharepoint.stackexchange.com/questions/138098/schedule-a-workflow-to-run-everyday
https://sharepoint.stackexchange.com/questions/138098/schedule-a-workflow-to-run-everyday
这将每天运行所有这些工作流程。也就是说，缺点是如果您的工作流程以某种方式损坏或服务器重新启动，很可能所有工作流程都会停止，您必须再次手动启动它们。更简单的
方法是通过创建一个每晚运行的计时器作业。
That will run the workflow on all of them each day. That said, the drawback is that if your workflows somehow get corrupted or the server restarts, it is very possible all workflows will stop and you'd have to manually start them again. The more foolproof way to do this would be by creating a timer job that runs every night.
https：// docs .microsoft.com / zh-CN / previous-versions / office / developer / sharepoint-2010 / hh528519（v％3Doffice.14）
https://docs.microsoft.com/en-us/previous-versions/office/developer/sharepoint-2010/hh528519(v%3Doffice.14)
这里的一个关键是，除非项目本身已更新，否则您的今日计算将不会更新。因此，如果您今天创建了一个项目，那么使用today函数的列将显示10/31/2018，直到该项目再次被修改。如果您已经在工作流程中使用
，则可以使用设置为"当前日期"的工作流变量。达到同样的效果。
One key thing here is that your Today calculation will not update unless the item itself is updated. So if you created an item today that column that uses the today function will show 10/31/2018 until the item gets modified again. If you're already using a workflow, you can use a workflow variable set to "Current Date" to achieve the same effect.
这篇关于使用计算列和& ;;触发SharePoint列表工作流程让它每天都重演。的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
