Jump to content
Claris Engage 2025 - March 25-26 Austin Texas ×

Check if field value is in value list via script?


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

Recommended Posts

Posted

Hello,

I have a few popup lists. I would like to check if the data the user entered is in a value-list.

I'm using something like this to do this in script and it works almost perfect.

if [ PatternCount ( ValueListItems ( Get (Filename) ; "StatusTypeValueList" ; Tasks::Status ) = 0 ]

set field [ Tasks::gMatched ; 0 ]

else

set field [ Tasks::gMatched ; 1 ]

end if

Code elsewhere does something with the gMatched to display a message and/or so on.

So, suppose I have in my StatusTypeValueList the following values : Open, Closed, Pending

If I click in the drop down list of the status field in a task layout, I can pick any of these - but if I am crafty, I can also type in something different. If I type in "Op" (no quotes) or "Close" , then my test above will still pass. I want it to only match the exact item in the list - so it must be "Open" and "Closed" which are typed.

What do I have to change to get it to only match items in the list?

thanks for your help in advance,

Sincerely,

J__

Posted

Add a pilcrow to the search term:

if [ PatternCount ( ValueListItems ( Get (Filename) ; "StatusTypeValueList" ) ; Tasks::Status & par.gif ) = 0 ]

This topic is 7243 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.