I have created a customised 'Listbox' using :
=If(Match($Field, 'Description', 'Product Description''), $Field)
And on the table of data I only want the specific listbox selection to appear, so I have written this in the expression of each column>
SubstringCount(concat( distinct $Field,'Listbox') , 'Description')>0
SubstringCount(concat( distinct $Field,'Listbox') , 'Product Description')>0
I have several over columns and they all work fine, however the above two. When I select 'Product Description' on the listbox, it brings back both Description & product description columns, when I select Description it works fine and displays the description column. I believe that is because of the word Description?
Can anyone assist me here, so when I select Product Description on the listbox, I will only have that column appear.
| is something unique which won't be available in your field values. That is why i used them, but you can anything else also such as @ or # which you think won't be in your field values. Nothing special about pipe |
Does this make sense?