Solved

sharepoint validation

Posted on 2013-06-20
1
180 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 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

Announcing the Most Valuable Experts of 2016

MVEs are more concerned with the satisfaction of those they help than with the considerable points they can earn. They are the types of people you feel privileged to call colleagues. Join us in honoring this amazing group of Experts.

Question has a verified solution.

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

Since upgrading to Office 2013 or higher installing the Smart Indenter addin will fail. This article will explain how to install it so it will work regardless of the Office version installed.
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…
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:
This video shows and describes the main difference between both orientations in Microsoft Word. Viewers will understand when to use each orientation and how to get the most out of them.

749 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