Have to select the Priority(Critical,High,Medium,Low) based upon the received and current date using Infopath forms or event receivers.

Code to auto calculate the field current date based on the received date and the priority

Ex:

If received date and the cureent date difference is <=5,

ReceivedDate:9/9/2015

CurrentDate:9/13/2015

priority:Critical

it should display the priority as critical, the received date and current date between(5,10) it should didplay Priority "High"

Critical

WORKDAY(received date,5)

High

WORKDAY(received date,10)

Medium

WORKDAY(received date,15)

Low

WORKDAY(received date,20)

Could you please help on this , is it possible by using infopath forms or event receivers



September 13th, 2015 7:35am

Hello Ravikiran Velama,

 

Event Receivers or InfoPath will make changes when an item is updated.

I think for this purpose, it is better to create a custom timer job that runs every day.

A timer job is a periodically executed task inside SharePoint Server. For example we can send emails or make changes in a list periodically.

For each list item you can compare Received Date column with todays date and change the Priority column depending on the comparison result.

Here is information about how to create custom timer jobs:

 

https://www.simple-talk.com/dotnet/.net-tools/a-complete-guide-to-writing-timer-jobs-in-sharepoint-2010/

http://www.codeproject.com/Articles/403323/SharePoint-Create-Custom-Timer-Jobs

 

Thank you

Free Windows Admin Tool Kit Click here and download it now
September 14th, 2015 2:55am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics