0 Replies Latest reply: Jun 6, 2012 5:50 PM by Ben Steineman RSS

    Alternate States - Field Event Triggers

      Hello,

       

      This is my inline table:

       

      TimeExpressions, TimeYear, TimeMonth

      Year over Year, sYearOn, sMonthOff

      Month over Month, sYearOff, sMonthOn

      Custom State, sYearCustom, sMonthCustom

       

      These are the Variables:

       

      SET sYearOn =             =max({<Year=A::Year>} Year)-1

       

      SET sYearOff =             ='=sum({<Year=A::Year>}1)'

       

      SET sYearCustom =     ='=sum({<Year=B::Year>}1)'

       

      SET sMonthOn =           =max({<Month=A::Month>} Month)-1

       

      SET sMonthOff =           ='=sum({<Month=A::Month>}1)'

       

      SET sMonthCustom =   ='=sum({<Month=B::Month>}1)'

       

       

      I have 2 Alternate States, "A" and "B". Each state has its own Year and Month list box.

      I also have a "TimeExpressions" list box I created in the Inline table. (Make sure to set the TimeExpressions list box to Alternate State "A")

       

      Under Field Event Triggers located at : Settings->Document Properties->Field Event Triggers->Year Field & Month Field

       

      For the Year Field Event Trigger I set:

      OnSelect->Edit Actions->

      Actions :                Select in Field

      Field :                     Year

      Alternate State :     B

      Search String :      =$(=TimeYear)

       

      For the Month Field Event Trigger I set:

      OnSelect->Edit Actions->

      Actions :                Select in Field

      Field :                     Month

      Alternate State :     B

      Search String :      =$(=TimeMonth)

       

      The way this works is when I select values in the list box called "TimeExpressions". I can click on Year over Year and all my values from State "A" Year and State "A" Month are transfered to State "B" Year and State "B" Month, minus 1 year.

      It works the same way with Month over Month but the Year stays the same and the Month goes back 1 month.

       

      The issue is with the Custom State Selection, I'd like it to simple stop transfering the values from State A to State B and allow me to click my own custom field values in State B.

       

      What's odd is this:

       

      SET sMonthOff =           ='=sum({<Month=A::Month>}1)'
      (This copies the same value from State "A" Month to State "B" Month,

       

      SET sMonthCustom =   ='=sum({<Month=B::Month>}1)'

      (This SHOULD copy the same value from State "B" Month to State "B" Month, or leave it the same, when I place this value directly into the Field Event Trigger without a variable it works!)

       

      Is there a different syntax I can use to disactive this and allow me to select my own values from State B again? instead of   " ='=sum({<Month=B::Month>}1)' "     

       

      Any suggestions would be much appreciated.

      I've attached a simple QVW of all of this put together.

       

      Thank you