How can you do conditional actions? (without macro)

[andrea_derossi]

Hi All,

Scenario: I have a button with 10 actions (for example 10 selections or other but not macro).

One example: if the filed doesn't have any selectable value then I need to skip the other actions, and write one varible that i use as alert.

is It possible?

Thanks all

Andrea

[stephencredmond]

Hi Andrea,

You can't put a conditional branch in a sequence of actions without macros.  However, what you might want to consider is having different buttons visible depending on conditions.  That might solve your issue.

Regards,

Stephen

[#3]

I recently needed similar funcionality and resolved it using the following in my actions:

=if(GetPossibleCount(Field)>0,Field,0)

[#4]

Just in case anyone else stumbles upon this, the solution I've used is to set a variable

vDateSelection=

if(

     isNull(GetFieldSelections(Date.Year_Month)),

     vMTD,

     '("'& Concat(DISTINCT(Date.Year_Month),'"|"') & '")'

)

I then set Date.Year_Month to vDateSelection when I go on to a tab.

regards

Graham