I'm trying to use the conditional show property for an object. I want the condition to be based on if the user has selected a value in a list box that is in an alternate state. How can I write a conditional show expression to accomplish this?
Say the alternate state is Alt1. The list box field is Year. I would have thought there was something like:
If you have a field in the default state that matches the one in the comparison state, you can count all values in the field from the default state and subtract a distinct count from the comparison state. If the value is less than zero, then something has been selected. Its not pretty, but here is an example: