I have a form with a filed that called Submit status, it's contain two value: Save as draft and submit to manager.
I want to send automatically emails every 28th of each month, to the person that their submit status is : Save as draft.
Can you help me?
Best answer by nanettedv
Hi Bahareh
In that case I would recommend creating a site workflow to loop through items in the list and send notifications to the initiator. The site workflow can then be set to run on a schedule on the 28th of every month. I've added a basic overview of what you need to do below:
Go to site contents and select Nintex Workflow for Office 365
Create a site workflow
Use Query list to build up a collection of list items that are still in draft. You can output every column you want to reference in the email to a separate collection variable (we can call them column collections).
Use a for each to loop through each item in one of the column collections.
Use the index output to get the value of the fields stored in the other column collections (Get Item from Collection). Send an email to the user with relevant information and a link to their draft item. To get an idea of what all you can do with collections, you can do a search for "collection" in the Actions pane.
Publish the workflow.
Go back to the Nintex Workflow for Office 365 page where you created the site workflow from. You will see your new workflow there. Select the ellipsis on the right and add a schedule to it.
Set the first run date, e.g. 28 May. Set recurring to every 1 Month.
I assume the form's Submit Status field is connected to an item column.
In the Nintex Workflow for that item,
do a date calculation to create the next date of 28th.
Add a "Pause until date" action to pause the workflow until that date.
Add a "Loop with condition" and set the condition when the Submit Status field equals Draft
Send email and perform other tasks.
Before the loop ends, add another date calculation for the next date of 28th.
Add another a "Pause until date" action inside the loop, just before the end node. This will wait for the date and then check the Submit field again. If it is still draft, the workflow will send the notification. If it has changed, the workflow will exit the loop and continue on with the workflow.
The workflow will have the following basic layout:
When Nintex is added in Office 365 it behaves differently than in an on-premises deployment. There is no feature to activate and it does not appear under Workflow Settings on the ribbon. Instead, to create or view workflows on the list, you click on the Nintex Workflow option that now appears on the ribbon. See this link to get you started.
Also remember to enable the following site feature to allow your workflows to read items and write changes to items/ lists/ libraries/ etc.:
In that case I would recommend creating a site workflow to loop through items in the list and send notifications to the initiator. The site workflow can then be set to run on a schedule on the 28th of every month. I've added a basic overview of what you need to do below:
Go to site contents and select Nintex Workflow for Office 365
Create a site workflow
Use Query list to build up a collection of list items that are still in draft. You can output every column you want to reference in the email to a separate collection variable (we can call them column collections).
Use a for each to loop through each item in one of the column collections.
Use the index output to get the value of the fields stored in the other column collections (Get Item from Collection). Send an email to the user with relevant information and a link to their draft item. To get an idea of what all you can do with collections, you can do a search for "collection" in the Actions pane.
Publish the workflow.
Go back to the Nintex Workflow for Office 365 page where you created the site workflow from. You will see your new workflow there. Select the ellipsis on the right and add a schedule to it.
Set the first run date, e.g. 28 May. Set recurring to every 1 Month.