Tutorial

Validate Empty Columns

Infowise allows you to do a wide range of validation on your columns. One of the most commonly used validation techniques is to ensure that information has been entered into a field. Infowise allows you to easily validate empty columns and alert the user if there is an issue.

Instructions

Navigate to your list and then to the Infowise Column Validation screen.

  • In the first drop-down, choose the column that you would like to validate. In this case, we are validating that the Project Owner column is not empty.
  • Select ‘Column, in type and set the ‘Operator’ to not equals
  • Leave the Value blank
  • Add an error message that lets your user know that the column cannot be blank
  • Check the ‘Validate Empty Columns’ checkbox
  • Hit the Save button

 

To ensure that our validation is working as we expected. we head over to our form to test. As expected, we get an error when we try to save the form without filling out the Project Owner column.

 

Summary

Ensuring that your field is fully complete before allowing the user to continue is a critical component of any successful application.

Last modified: 5/24/2017 8:29 PM
6 comments [latest: 1/29/2018 7:33 PM]
Dawn [8/2/2017 1:21 AM]
This is wonderful. However, I followed directions and I keep getting the message "Add a validation rule"
Vladi Gubler [8/2/2017 2:05 PM]
Dawn: try putting it in as Column Length = 1 instead.
Scott [1/25/2018 2:19 AM]
This does not work. I get the same error. I do not want to validate based on length but on whether a choice (radio buttons) have been selected. Anyone know how to do this?
Derek Kent [1/25/2018 2:33 AM]
@Scott - Can you send an email to support@infowisesolution.com regarding this issue. If possible can you provide screenshots of your column validation settings along with your choice column settings.
Dan [1/27/2018 3:42 AM]
Is there a way to validate to check if there's a space before the text string input?
Vladi Gubler [1/29/2018 7:33 PM]
Dan: you can, using regular expressions. You can find the necessary format online, according to your requirement.
 
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.