cancel
Showing results for 
Search instead for 
Did you mean: 
chamank
Nintex Newbie

How do I implement mail reminder in standard SharePoint task list until the task is completed and 7 days from due date in a item of task list

Jump to solution

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? *)

0 Kudos
Reply
7 Replies
Automation Master
Automation Master

Re: How do I implement mail reminder in standard SharePoint task list until the task is completed and 7 days from due date in a item of task list

Jump to solution

Hi

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:

https://community.nintex.com/community/build-your-own/blog/2016/05/23/site-workflow-document-review-...

https://community.nintex.com/docs/DOC-4147

Looks like you want to send reminders where the task is not complete and the due date <= a week from today is that correct?

0 Kudos
Reply
Automation Master
Automation Master

Re: How do I implement mail reminder in standard SharePoint task list until the task is completed and 7 days from due date in a item of task list

Jump to solution

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.

see following posts https://community.nintex.com/search.jspa?q=%22iso+format%22&author=%2Fpeople%2F8567 

Reply
chamank
Nintex Newbie

Re: How do I implement mail reminder in standard SharePoint task list until the task is completed and 7 days from due date in a item of task list

Jump to solution

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 ! 

0 Kudos
Reply
Automation Master
Automation Master

Re: How do I implement mail reminder in standard SharePoint task list until the task is completed and 7 days from due date in a item of task list

Jump to solution

oops sorry I didn't see your attachment!

0 Kudos
Reply
chamank
Nintex Newbie

Re: How do I implement mail reminder in standard SharePoint task list until the task is completed and 7 days from due date in a item of task list

Jump to solution

>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 ? 

0 Kudos
Reply
chamank
Nintex Newbie

Re: How do I implement mail reminder in standard SharePoint task list until the task is completed and 7 days from due date in a item of task list

Jump to solution

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 ? 

0 Kudos
Reply
Automation Master
Automation Master

Re: How do I implement mail reminder in standard SharePoint task list until the task is completed and 7 days from due date in a item of task list

Jump to solution

Yes you can use -7 in calculate date. Please mark an answer correct to close out the thread. Thanks 

Reply