View filter formula based upon multi value column
Posted on 2007-03-29
I have an interesting request.
I have a form that has all unique field values, however I allow multiple entires of a certain type. Such as, I have a small table in the form that allows for element names (elm1,elm2,elm3,elm4, etc) under 1 form entry clasified by say 1 pkg ID. So lets say pkdID 1234 includes 6 elements, elm1 - elm6. I have a view that I've created by element, I have indicated multiple values new line and separate entries as new line. So I'm getting 6 different rows for 1 pkg. Exactly what I want. Now I want to filter the element by a particular value. I have no idea how to code the view formula to filter on element values of say show me a new line for every elm that is equal to "YES" only.
Here is the element column in the view.
this will not show me an entry that does not have an element value.
Now I only want separate rows for elements that equal "YES"
Hope this makes sense.