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
