Test for value in drop down value list

[Rainy Pass]

Is it possible to test for the existence of a value in a drop down value list? I am trying to build a script (triggered on field entry) to auto enter a value, if that value is in a drop down value list.

[Fitch]

You could use ValueListItems and then FilterValues to test for the one you want.

[Rainy Pass]

Thanks, I'll see if I can't make it work.

[Rainy Pass]

I can't seem to capture the value in drop down list. Any suggestions, what am I missing?

The following returns a null value:

FilterValues (

ValueListItems ( Get ( FileName ) ; "ORLI Color via Product Style" ) ; "na"

)

As does:

ValueListItems ( Get ( FileName ) ; "ORLI Color via Product Style" )

[comment]

Perhaps you have the same issue as here:

http://fmforums.com/forum/showtopic.php?tid/214453/post/355084/#355084

[Rainy Pass]

No. But thanks.

The calc is in a script step. And is set up a couple ways in Data viewer.

I get nothing

Does anyone, or can FM extract data from the drop down lists?

[comment]

Are you sure the name of your value list is EXACTLY "ORLI Color via Product Style"?

[Fitch]

Does your value list use related values, and if so are you in the right context to see the related values?