Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I'm trying to set variable vButton=1 when the current year is selected and no selections are made in other calendar fields (QUARTER, MONTH, MONTH-YEAR). This will change the color of my YTD button.
I tried to add a Trigger Action under Document Properties, but the Field Event Triggers don't allow me to prescribe a condition like below. Can anyone help??
(GetFieldSelections(YEAR)=YEAR(Today()),vButton=1)
to change the color of a button add an expression for Calculated in the color of the button
something like (adapt to your requirement)
=if(GetPossibleCount(SerialNumber)=1 and GetPossibleCount(Year)=1,red(), green())
I don't think you need a variable and/or trigger
create a calculated color for the text box (background) like
=if(getselectedcount(year)=1 and getselectedcount(month)<>1 and getselectedcount(monthyear)<>1
, newcolor(), oldcolor());
-Sundar