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.

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

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

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" )

Perhaps you have the same issue as here:

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

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?

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

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