Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I created inline data to populate a list box
Load * Inline [
Display
Change
Percent
];
I want to allow the user to hide columns in a straight table. I can hide a single column using Presentation Conditional with an IF Statement if(Display = 'Change' ,0,1)
However I am unable to use Like And etc to hide when the the user selects BOTH Change and Percent. What syntax would I use in the if statement to allow both columns to be hidden when the user selects both values in the list box?
Appreciate any advise.
Try:
=if(FindOneOf(GetFieldSelections(Display), 'Change'), 0, 1)
When multiple items are selected, I needed to use GetFieldSelections on the field instead of just using the field name directly.
Hi
something similar, used a macro to check on selected items
Jürg