?
Solved

sharepoint validation

Posted on 2013-06-20
1
Medium Priority
?
187 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 (Microsoft MVP / EE MVE) earned 2000 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

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

Question has a verified solution.

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

Currently, there is an issue with being able to copy values from an external application to a dropdown list in Project Web Access (PWA).  The standard copy and paste methods don't seem to work properly. Here is a way to accomplish this task to s…
If Skype for Business came with your office 2016 or office 365 installation, you may find that it's almost impossible to either disable or remove it. The application will often launch with each start of Windows, even when explicitly configured not t…
Do you want to know how to make a graph with Microsoft Access? First, create a query with the data for the chart. Then make a blank form and add a chart control. This video also shows how to change what data is displayed on the graph as well as form…
Visualize your data even better in Access queries. Given a date and a value, this lesson shows how to compare that value with the previous value, calculate the difference, and display a circle if the value is the same, an up triangle if it increased…

571 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