Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi together,
does anyone know how to write the condition for the inquiry if the months of the actual year are selected by the user?
I want that the button is colored black when the selection of the User corresponds with the set standard selection of the button.
Light grey= not active
Black= active
Goal: Today > May 2016
If the user select exaxtly: 2016 + 01, 02, 03, 04, 05 then the button should be black
That are the settings of the button:
=If(GetFieldSelections(Jahr)= year(today()) and GetFieldSelections(Monat)<= month(today()), 'qmem://Icon/Icon_Home_px256_Black', 'qmem://Icon/Icon_Home_px256_Grey238')
The red part is wrong. By this way the button is black once a month selected by May.
=If(GetFieldSelections(Jahr)= year(today()) and GetFieldSelections(Monat)= '01, 02, 03, 04, 05', 'qmem://Icon/Icon_Home_px256_Black', 'qmem://Icon/Icon_Home_px256_Grey238')
But how to write something in a changeable form (dynamic)?
Greetings
Lisa
Try below
=If( GetFieldSelections(Jahr)= year(today()) and GetFieldSelections(Monat)= concat(ValueLoop(1,num(month(today())),1),', '), 'qmem://Icon/Icon_Home_px256_Black', 'qmem://Icon/Icon_Home_px256_Grey238')
How about this:
=If(GetFieldSelections(Jahr) = Year(Today()) and RangeMax($(=GetFieldSelections(Monat))) <= Num(Month(Today())),
'qmem://Icon/Icon_Home_px256_Black', 'qmem://Icon/Icon_Home_px256_Grey238')
go to the listboxand go to the action tab to give action selection in field to get the out put
May replace it with something like
count({1<nMonth={"<=$(=max(nMonth))"}>}DISTINCT nMonth ) <=num(month(today())
Try below
=If( GetFieldSelections(Jahr)= year(today()) and GetFieldSelections(Monat)= concat(ValueLoop(1,num(month(today())),1),', '), 'qmem://Icon/Icon_Home_px256_Black', 'qmem://Icon/Icon_Home_px256_Grey238')
Hi Perumal,
great ... thank you, it is working :-).
Will you please help me with the formatting?
I do not get it into the right form > I need two decimal places.
My experiments with the num function were unsuccessful.