Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi There
I am stuck here with this seemingly simple problem but have tried loads of different things over the last 2 days with no luck and cannot think what else to try.
My problem is that when I select more than 6 items in my 'Display Column' check box, it displays the wrong columns
First 6 items selected (can be any 6) - all ok
When I select the seventh column (any column) it displays the wrong columns
FYI I have changes the number of Max Values in Current selections to 50
Any ideas please?
Best Regards, Steve
Hi Johan
Thank you very much. You helped a lot. For anyone else out there my finished code per column was:
=if(substringcount(GetFieldSelections(Columns, '', 30), 'P.H. Code')>0, true(),false())
Thank you.
Steve
I have noticed that when I get to selecting a seventh column it now displays the inverse (non selected) columns. Any suggestions please.
The defenition looks like:
str GetFieldSelections (field_name [, value_sep [, max_values=6]])
so try with GetFieldSelections(Columns, ',', N), where N is the number of maximum columns.
Hi Johan
Thank you very much. You helped a lot. For anyone else out there my finished code per column was:
=if(substringcount(GetFieldSelections(Columns, '', 30), 'P.H. Code')>0, true(),false())
Thank you.
Steve