Field Tiggers

[mparker123]

Hello All,

I am having trouble with the field triggers. I have a straight table on one tab, within this straight table I have a field called epic_summary. I am setting a field trigger on this field so when I click on it, it will take me to the the next tab and show me the filtered items. (I have tried Activate sheet, Activate Next Sheet, and Set Variable) These work but it also mess my document.

For instance I have 5 tabs and the field appears on each tab, when I am on the 1st tab and click on the field it takes me to the 2nd tab which is want i want it to do. However, when I click on the same field on the 3rd and 4th tab it will do the same things. I want it so that the first tab and second table filter together and the rest do not.

Is this at all possible and if it is how is this done?

[krishnacbe]

Hi,

You can add another condition with GetActiveSheetId() along with Field Trigger and create a Variable value with AND Condition.

[prieper]

Think that you will have to create another field, without the above trigger.

edit:

Krishnapriya's solution looks better

[mparker123]

Can you please elaborate.

I go into document properties and I select the field in the Field Event Triggers box. I am presented with 4 options (OnSelect, OnChange, OnLock, OnUnlock). I click on the add action on the OnSelect option. I click add and go to the action type LAYOUT and select the action ACTIVATE SHEET. Here it just ask for a Sheet ID so I assume this is not what you mean.

OR

I go into document properties and I select the field in the Field Event Triggers box. I click on the add action on the OnSelect option. I click add and go to the action type EXTERNAL and select the action SET VARIABLE. In this expression i write a condition with GetActiveSheetId() but use an and statement to control what sheet and when do i want it activated.

[krishnacbe]

I meant the second option you explained

[krishnacbe]

I tried below expression OnSelect() event of the Field Event Trigger. It worked.

=if(GetActiveSheetId()='Document\SH11','SH09','SH08')

[vvira1316]

Have you explored alternative state for sheet 3 and 4 (may be other sheets and fields all will have to be in the same state so will have different interaction). so filter field will have a one state for sheet 1 and 2. They will behave in sync and due to alternative state on 3 and 4 it will not impact them and vice versa.

[mparker123]

That works, however if I Move to a tab not included in the expression above, when I go to filter a straight table on this new tab with the epic_summary field the straight table disappears and I have to click out of the tab and go back into the tab to see the filtered table. Is there a way to fix this?

[mparker123]

I have set alternate states as well, this does not seem to solve the issue of the straight table disappearing.

[krishnacbe]

For testing I Tried navigating to other tab in the expression. Hope in your expression the else will be blank.. Am I right?