Solved

sharepoint validation

Posted on 2013-06-20
1
177 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:
Ingeborg Hawighorst 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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Recently Microsoft released a brand new function called CONCAT. It's supposed to replace its predecessor CONCATENATE. But how does it work? And what's new? In this article, we take a closer look at all of this - we even included an exercise file for…
These days socially coordinated efforts have turned into a critical requirement for enterprises.
This video shows where to find templates, what they are used for, and how to create and save a custom template using Microsoft Word.
The viewer will learn how to simulate a series of sales calls dependent on a single skill level and learn how to simulate a series of sales calls dependent on two skill levels. Simulating Independent Sales Calls: Enter .75 into cell C2 – “skill leve…

910 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

17 Experts available now in Live!

Get 1:1 Help Now