Jump to content

Data Validation


This topic is 7353 days old. Please don't post here. Open a new topic instead.

Recommended Posts

  • Newbies

I have a pop-up list fo data that starts with Please make a selection... I want to make it so that this can not be one of the submited answers. I can not figure out how to return an error when this is not changed to one of the choices in the list. any help would be very appreciated.

Link to comment
Share on other sites

Hi 6,

I would use a calculation field in connection with your current field.

For the sake of explanation, lets call your current Field "Value Field" and the new Calculation Field "c_Please Enter"

c_Please Enter, Calculation, Text Result =

Case(IsEmpty( Value Field ), "Please make a selection...")

Note: Make the Calculation field "No Entry" and "No Fill" and put it on top of "Value Field"

HTH

Lee

Link to comment
Share on other sites

This topic is 7353 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.