I'm a beginner for Nintex who looks for help. Recently I created a Site workflow where it sent the user a reminder when the due date is 7 days from that date. the user set due date in the item of SharePoint standard task list (i.e. send email notification today when the field of item in SharePoint standard task list has a due date of 2/15)
Also, I need another decision that send notification until task status is completed.
However, I could not do this in the workflow I created.
Could someone help me? *)
Solved! Go to Solution.
Can you show us what you have set up to date - and is it working?
I have a blog post here and solution on Xchange here if they are any help:
Looks like you want to send reminders where the task is not complete and the due date <= a week from today is that correct?
what exactly you mean with 'here is what I stucked'? do you mean condition on complete status do not work?
does your query work with only date condition?
I would say there is no problem with your condition on status but rather with date condition. you provide there variable of datetime datatype whereas CAML expects date string in ISO format.
Thank you so much for your help.
>Looks like you want to send reminders where the task is not complete and the due date <= a week from today is that correct?
→Yes you are correct. one condition "due date" does work but the other one "status" does not work. in my word document, I made a mistake to set "ステータス is equal to Complete" but correctly this one is "ステータス is not equal to Complete". but it does not work correctly.
Is this setting correct where I pointed out on Word document ? I think the filter on Query List action can filter "Status is not equal to complete".
Anyway, I will read your article !
>Can you show us what you have set up to date - and is it working?
I'm sorry for my poor understanding .. which picture you want to see ?
Thank you for everyone. actually it was worked well after that. I don't know why it didn't work at the moment.
I have one more question how I set the reminder with 7 days after due date.
Is it correct to set "-7" in day value on Calculate Date action ?
Yes you can use -7 in calculate date. Please mark an answer correct to close out the thread. Thanks