Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have created a dynamic list box so I can have any amount of filters without taking up any additional space. It works wonderfully. The only caveat is that it does not indicate when a selection has been made on a field, the way a list box or multi box would. I have tried my best to make a getcurrentselections function work on a dynamic field.
Is there a way to put an indicator in an expression to show if there is a selection has been made?
Included is a dummy example file.
Eric, I am now using this expression in my List Box:
=subfield(
left(
mid(GetCurrentSelections('|','~'),index('|' & GetCurrentSelections('|','~'),'|' & only({1}$Field))),
index(
mid(GetCurrentSelections('|','~'),index('|' & GetCurrentSelections('|','~'),'|' & only({1}$Field)))&'|','|')-1)
,'~',2)
For sorting I use:
=index('|' & GetCurrentSelections('|','~'),'|'&only({1}$Field))
As Field I use $Field, so that my List Box currently shows all avilable fields and if a selection is made you can see the selection in the expression.
Regards
Norbert
Not exactely sure what you are asking for, I do see the selection on value male as in a normal list box:
Eric,
try this expression
=concat({1}
aggr( concat({<_FilterField=>} if(_FilterField='email', GetFieldSelections(email),
if(_FilterField='first_name',
GetFieldSelections(first_name)))),_FilterField))
in your "Field to Filter On" List Box. This will display the selections made in all the fields.
If you don't have too many fields, this could be a solution.
I think $ sign expansion will not work as it is executed "too early".
Regards
Norbert
Eric, I am now using this expression in my List Box:
=subfield(
left(
mid(GetCurrentSelections('|','~'),index('|' & GetCurrentSelections('|','~'),'|' & only({1}$Field))),
index(
mid(GetCurrentSelections('|','~'),index('|' & GetCurrentSelections('|','~'),'|' & only({1}$Field)))&'|','|')-1)
,'~',2)
For sorting I use:
=index('|' & GetCurrentSelections('|','~'),'|'&only({1}$Field))
As Field I use $Field, so that my List Box currently shows all avilable fields and if a selection is made you can see the selection in the expression.
Regards
Norbert
That looks perfect!!! I am not going to display the actual selections, just an asterisk. But this gets me what I need. Your awsome, thanks.