1 of 1 people found this helpful
What exactly is the form of the content of the "Scene::Furniture" field? It sounds like you have multiple values in it.
Is it like this:
Or something more like:
Table, Chair, Rug
I'm going to assume the first option, a return separated list. If so, then you could use FilterValues() to check for the presence of "Table" in the list. If the FilterValues() function returns empty, then the word "Table" does not exist in your list. E.g.:
isempty ( filtervalues ( "Table" ; Scene::Furniture) ) )
This will be completely independent of the "Massage Table" entry, if it is in your list, because FilterValues() compares the entire line, not just the word.
1. You have a field in which the user selects the value "Table", and that this field is entered from a Value List.
2. You have a second field with an associated Value List giving various types of Tables.
I would think, therefore, that you would want this second field to be hidden whenever the first field is NOT "Table", so the Hide condition should be: firstField ≠ "Table".
Now I am not clear whether Massage Table is an option in the first field or the second. Since you post it as messing things up I assume it is in the first field. If so, then it will certainly trigger visibility of the second field, since it includes "Table" as a separate word. A simply fix might be to make sure the value is recognised as a single word instead, which could be achieved either by (1) entering a hard space between Massage and Table, or (2) using camel case: MassageTable; and ensuring the field is populated with this value.
@justinc ... that was exactly what I needed. thank you!
Cool, glad to hear it!