Filter Fix in Each Sheet

[#1]

I'm not sure whether is it possible or not so I'm asking to all of you...Can I set my filter fix for each page? That is, I have 3 sheets: Green, Streets, Float and according to the filter data changes (obviously), but then I would like that in the Green page, I highlight Green (and see Green) BUT AT THE SAME TIME in the Streets sheet I can highlight Street and see their data...is it possible?

[bbi_mba_76]

Hi,

maybe you can add actions on the onopen trigger of each sheet to select the value.

On the sheet properties-triggers-onopen add actions and select in Field your sheet-value

[jonathandienst]

Hi

You could set the filter using an action triggered by OnActivateSheet on each sheet.

Or you could set an alternate state on each sheet, manually make the selections and then use the menu option Selection | Set Clear state to make those selections the default.

HTH

Jonathan

[its_anandrjs]

Use field event triggers in the sheets.

[#5]

Thank you all, I was think about the trigger for each sheet, but I don't know how to use it...what should I write in "FIELD" and in "SEARCHING VALUE"? As you can see my only selection is from the table "Struttura" and in the picture is VERDE ORNAMENTALE...

[sudeepkm · Accepted solution]

if you want to have the field value selected and locked then you need to set the action like below.

[#7]

Sudeep Mahapatra thank you!!!! That's what I was looking for!!! I must do that for each sheet right? So that each page is Blocked with the correct selection...

[sudeepkm]

if you have the same value (for example 'VERDE ORNAMENTALE') of the field Struttura to be selected in every sheet then keeping it on the first sheet or keeping it when the document opens should work.

In case your requirement is to change the value when you go to other sheets then on each sheet you need to apply the action by putting the Field's new value under Search String.

[#9]

I have a different value for each sheet, I must change the String Value....but when I open the document, will every selection remain fix? I have always add the "Block Field" action...

[#10]

yes it remains!

thank you once more Sudeep Mahapatra