Jump to content
Sign in to follow this  

validation of a field

Recommended Posts


I have a list layout with one field "Food And Drinks" that you can add (new record) the kind of food or drinks (wines, meat, soft drinks, veg, beers....). i did that because i want that, each time you add a kind of food or drink at the "Item" field of the invoice and you click the "ADD" button, i want that a script check if you have choose the type of service (Room service, Restaurant, Bar) for this Food or Drinks. BUT only when the "Item" at the invoice is one of the "Food And Drinks" record of the list layout.

My problem is that i can't find how the script can check if the field "Item" content one of the "Food And Drinks".

Sorry for the English!!!

Share this post

Link to post
Share on other sites

Not IsEmpty ( FilterValues ( Item ; Food And Drinks ) )

returns 1 ( true ) if Item is a value of the list, else returns 0 ( false )

BTW: you can turn on the validation of Item as member of a value list coming from the field Food And Drinks

Share this post

Link to post
Share on other sites

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
Sign in to follow this  


Important Information

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