Tutorial

Validate numeric / date values

When doing validation for numbers or dates, the column selection is used.

NOTE: The features described are for use with the Classic-style Form Builder. If you are using the SharePoint Modern experience, our recommendation is to use the newer Form designer tool – validation is one of the functions controlled as a part of that, rather than as a stand-alone.

Instructions

  • Use the column validation rule to check numeric values.
  • You may compare values of other numeric fields including dates.
  • In this example, we want to validate that the Due Date is after the Kickoff Date:

  • This will block the user from entering a field value based on the value of another field:

Summary

The Column validation setting is intended for fields with numeric values including dates. When doing validation it is useful to compare against other field values to set up compound conditions.

Last modified: 10/1/2019 3:44 PM
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.