Solved

sharepoint validation

Posted on 2013-06-20
1
182 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
1 Comment
 
LVL 50

Accepted Solution

by:
Ingeborg Hawighorst (Microsoft MVP / EE MVE) 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

PeopleSoft Has Never Been Easier

PeopleSoft Adoption Made Smooth & Simple!

On-The-Job Training Is made Intuitive & Easy With WalkMe's On-Screen Guidance Tool.  Claim Your Free WalkMe Account Now

Question has a verified solution.

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

This article descibes how to create a connection between Excel and SAP and how to move data from Excel to SAP or the other way around.
This article describes how you can use Custom Document Properties to store settings and other information in your workbook so that they will be available the next time you open the workbook.
The viewer will learn how to make their project stand out over others by learning how to change colors and shapes, add spaces, change directions, and add bullets to their charts.
The viewer will learn how to use the =DISCRINV command to create a discrete random variable, use this command to model a set of probabilities and outcomes in a Monte Carlo simulation, and learn how to find the standard deviation of a set of probabil…

724 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