Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a field which is a multi-pick list so when I apply a filter it looks like;
Brand
WFI
NFI;PFI
PFI
WFI;NFI;JFI
JFI
NFI
I would like to group the filters so all organisations operating under the NFI brand are highlighted when selected regardless of what other brands they are also attached to. Is there a way to do this in the filter pane?
You can script it
NewFilter: LOAD Brand, SubField(Brand,';') as BrandFilter RESIDENT TableWithBrandField ;
Is there a way to tidy up the filter list so each brand only appears once rather than each combination appearing?
Yes, by creating an extra table in the script with a new field that you can use for the filter pane:
NewFilter: LOAD * INLINE [ Brand, BrandFilter WFI, WFI NFI;PFI, NFI NFI;PFI, PFI PFI, PFI WFI;NFI;JFI, WFI WFI;NFI;JFI, NFI WFI;NFI;JFI, JFI JFI, JFI NFI, NFI ];
What if there's thousands of different combinations? Is there a easier way of scripting this, maybe using wildmatch?
I tried the below but it looks like incorrect syntax.
NewFilter:
LOAD*INLINE [
Brand, BrandFilter
if(wildmatch([Brand__c],'*NFI*', 'NFI')
You can script it
NewFilter: LOAD Brand, SubField(Brand,';') as BrandFilter RESIDENT TableWithBrandField ;