Jump to content

newbie Field validation question


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

Recommended Posts

I need to make sure a number field "fieldA" is NOT empty when another text field "fieldB" has certain text in it.

I also would like a custom message alerting the user when this situation happens and they can't proceed until they add the data to the number field.

Please help!!! :)

Link to comment
Share on other sites

Welcome to the Forums!

Open Define Databse (Ctrl + Shift + D)

Choose fieldA, double click it

A window will come up with field options

Choose the validation tab

Click "validate by calculation"

Insert the following calculation which tests your conditions: Case("fieldB" = "specific value" and IsEmpty (fieldA) ; 0 ; 1)

Click ok to save the validation calculation

Then in the validation tab again, choose "display custom message if validation fails"

Insert the message for your user in the now white box.

Finally, if you don't want your user to be able to overide the data validation, still in the validation tab, unselect "allow user to override during data entry".

Good luck

~Genx

Link to comment
Share on other sites

Thank you Genx

I must be doing something wrong :)

I did what you said for some reason it did not validate :

here is the calc I created...

Case("Job created" = "new router" and IsEmpty (qty to be built) ; 0 ; 1)

"Job created" is the text field and "qty to be built" is the number field

Do you see anything I might be missing?

Link to comment
Share on other sites

Oops, sorry, my mistake, i only put FieldB in quotes because i was reading it off your example :), change it to be FieldB without quotes.. i.e.

Case(Job created = "new router" and IsEmpty (qty to be built) ; 0 ; 1)

Link to comment
Share on other sites

This topic is 5680 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
 Share

×
×
  • Create New...

Important Information

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