Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I have a field called %HistoricalMarket and one called %Market.
I have not made these two fields into the same field as it would create a loop in my data model.
To simulate that the two fields are the same, I have applied the following triggers:
%HistoricalMarket
On Select - Select in Field %Market
Search String - if(count(distinct %Market) =1,%Market
%Market
On Select - Select in Field %HistoricalMarket
Search String - if(count(distinct %HistoricalMarket) =1,%HistoricalMarket
This seems to work well, though when I select Clear Selections, these two fields will not clear. I can clear them manually within my Current Selections box by selecting the eraser icon.
Is there a way to add another trigger or modify the existing to ensure my Clear Selections button (using 'Clear All') will work on these fields?
Many thanks
Mel
Hi,
May i know on which trigger you are calling above two trigger?
I mean it is on ActivateSheet or something else.
Regards,
Hi Mel, if you want to transfer selections from one field to another it shouldn't be..?:
%HistoricalMarket
On Select - Select in Field %Market
Search String - if(count(distinct %HistoricalMarket) =1,%HistoricalMarket