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

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Sign in to follow this  

  • Create New...

Important Information

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