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?
Solved! Go to Solution.
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
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.
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...
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.
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...