Solved

sharepoint validation

Posted on 2013-06-20
1
176 Views
Last Modified: 2013-06-24
is it possible [and if it is could someone provide an example of the code] to make a [drop down] field change from its current state to 'pending' [which is one of the drop down choices]  if any of the cells are subsequently changed. i.e If someone goes back into the item after the item has been completed I need it to be able to move back into a differnt view, but the person making the amendment might not change the field back to pending so I need it to change if any field is amended.

Hope that is clear.

Thanks
0
Comment
Question by:Jagwarman
1 Comment
 
LVL 50

Accepted Solution

by:
teylyn earned 500 total points
ID: 39261909
Hello,

you could create a workflow that changes the state back to pending when the item is edited. This can be done with SharePoint Designer.

You will need to establish the logic and create a few conditions in the workflow, though. So, for example, if the approver approves the item and sets the status to "approved", then the workflow should NOT change the status back to "pending".

The devil is in the detail. You need to plan and map out exactly what happens when certain fields change and then let the workflow act accordingly.

If you need help with that, please pipe up.

cheers, teylyn
0

Featured Post

How to improve team productivity

Quip adds documents, spreadsheets, and tasklists to your Slack experience
- Elevate ideas to Quip docs
- Share Quip docs in Slack
- Get notified of changes to your docs
- Available on iOS/Android/Desktop/Web
- Online/Offline

Join & Write a Comment

No matter the version of Windows you are using, you may have some problems with Windows Search running too slow or possibly not running at all. Before jumping into how you can solve this issue, just know there are many other viable alternative deskt…
Using Word 2013, I was experiencing some incredible lag when typing.  Here's what worked for me....
This video shows the viewer how to set up and create Footnotes in their document. Click on the References tab: Select "Insert Footnote": Type in desired text:
The viewer will learn how to use a discrete random variable to simulate the return on an investment over a period of years, create a Monte Carlo simulation using the discrete random variable, and create a graph to represent the possible returns over…

762 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

21 Experts available now in Live!

Get 1:1 Help Now