Skip to main content
Nintex Community Menu Bar

I set up a workflow which has a trigger condition to check if the date in a column is = to the current date. If it is then the WF is triggered. However it not being triggered.

 

I was thinking about starting the WF when a new item is created and using the pause until action but I not sure how many rows will be in my list and have WFs running. If I had 100 rows all with WFs running will this be an issue.

 

I have a another WF which updates the current date column to the current date every day. I was thinking this would be the trigger for the WF above as the column has been modified? 

 

Please advise.

Thanks

 

 

 

Hi ​@michuk ,

Can you provide more context or details of the scenario you’re solving for? i.e. What is your overall need, what is the business process, etc? With this information we may be able to find a different solution to solve for your scenario. As much detail as possible would helpful.

Regards,

Kate


I have a list with a date column. It's a calculated column base on another column.

When that date = the current date I need the WF to start.

 


Hi ​@michuk,

Your option 1 of starting the workflow on item creation and letting it wait is okay, as long as it does not wait for more than a year. You can have as many workflows waiting as you like.

Your option 2 is probably not working because the date format between the calculated date and what the workflow uses as the current date is probably different.


Hi ​@michuk ,

Thanks for the extra details. Rather than the specific step you’re trying to build, I was looking for your broader business process, e.g.: The SP list is an invoice list. A new item is created when a new sales motion starts. Every day, I want all invoices that have a due date of ‘today’, to be escalated to the team.
Depending on the overall scenario you’re trying to achieve, there may be different solutions on offer.

In the mean time, does this scenario resonate with you - https://community.nintex.com/nintex-workflow-2/send-one-e-mail-based-on-multiple-items-updated-73310? This community user was looking for a scheduled capability, to collect multiple Sharepoint items for processing.
If your scenario is similar, perhaps Scheduled workflow might work for you too?

 


MichUK, the scenario provided in the link by kate is similar to what I would suggest and we use repeatedly. Set up a site workflow on a daily schedule and simply query the list of items for those whose Created or Modified dates match today. Then you can perform whatever action is needed on each of those items in the query’s result collection.

Hope this helps


Hi ​@michuk has your question been answered?


Reply