Enforce status progression through column validation
Vladi Gubler
Vladi Gubler
February 14, 2013 | Products

Hello,

We received this question from a client and wanted to share the answer with all of you, as many SharePoint users could find it useful.

The customer wanted to set up validation rules on a task list using Smart List Pro in such as way, that users would be allowed to change the task status only in a specific order:

  • Not Started
  • In Progress
  • Completed

So, for instance, a task that is not started cannot be change to Completed without first going through In Progress stage.

To do so, we would need to store the previous value of the status column. This value, hidden from users, will be filled out automatically and used by our validation rules. We will need to install both Smart List Pro and Smart ID Pro for this to work.

  • Add Old Status column to the list (it can be simple single line of text). Do not add it to the default view.
  • Using Advanced column permissions, set the column to be hidden in all forms, users do not need to see it.
  • Using Smart ID Pro set a rule to set Old Status column to the value of Status column

ID settings

Now we are ready to set up our validation rules.

Validation Rules

Number of rules is according to the number of status options, 3 in this case. For instance, rule #1 checks that the status value does not equal Completed when Old Status (the value of Status prior to attempted change) is equal to Not Started. This makes sure you cannot change from Not Started directly to Completed. The other two rules work in the similar way. The second rule makes sure you cannot change from In Progress back to Not Started. The third rule makes sure you cannot change Completed status to anything else.

You can also add rules to exempt your administrator, so you will have the ability to still change the values if a mistake was made. This is not shown here, but can be added just as easily.

When a user attempt to make an illegal change, he/she is blocked and the error message is shown:

Validation Error

 

Loading...

Add your comment

Comments are not designed to replace support calls. If you have a specific issue with one of our products, please send an email to support@infowisesolutions.com to open a support ticket.

UltimateForms

Build powerful business applications in SharePoint using only your browser.
100% No-Code Solution

It's never been easier, to create, innovate and share, all you need is your web browser!

Cost-effective

Address business process pain points immediately. Save time and money.

Fantastic Support Team

Facing difficulties installing the application? Contact our fantastic support team.

support@infowisesolutions.com

Related Topics

What is right for you?

Online Trial

Not ready to install yet? Create a trial site in our environment
  • Full control of the site and its settings
  • Optionally pre-install one of our solution templates
  • Site provisioned instantly
  • Automatically removed after 30 days
  • Available to everyone!

Error!

There was an error processing your request.
Please contact us for further details.

Installation

Install in your own environment, on Microsoft 365 and on premises
  • Start working with real users and data
  • Install online or on premises
  • Register for 30 day trial
  • Seemlessly convert to paid license
  • Requires administrator permissions

Success!

Download link has been emailed to .
If you do not receive it within 5 minutes, please check your spam.
The link is valid for 72 hours.
If you are having problems, please contact us.

Error!

There was an error processing your request.
Please contact us for further details.
Technical details:

Request a Live Demo

Book an appointment for a one-on-one with an ULTIMATEforms expert trainer.

Test drive the awesome power of ULTIMATEforms

Learn how to quickly and easily turn time-consuming business processes into automated, efficient workflows.

Have a strong start

Only thirty minutes of well-coached time can translate into great future savings in time and money. So, sit back and enjoy the ride.

It's Free

Learn how to address business process pain points immediately. Save time and money.