"Explicit" select in field

[tinkerz1]

Hi,

Is there a way to set up a button that only selects (colours green) when all the "select in field" parameters are met.

For instance in my example, I have 3 actions on State 1, they are all true and colour green.

But on State 2's Actions the selection France is not true, Mr B does not have product sales in Holland.

Is there a way not to trigger all of the selections if one of the selections is not true?

Thanks,

Neil.

[marcus_sommer]

This should be possible within if-loops which queries per getfieldselections() or getcurrentselections() the selections and which have since one of the recent service releases a fourth parameter for the state.

- Marcus

[#3]

Hi. In this case, set the last field on the list for the second button. Terms and conditions contradict each other.

[tinkerz1]

I dont understand how both of these comments relates to a button?

[marcus_sommer]

If you want to select anything with a button you will need to define an action with a value or a search-string to your desired field(s).

- Marcus

[#6]

OK.

You set the three fields. The first field is contrary to the installation of a third field. Runs the last installation for a third field.

[#7]

The value for the first field is contrary to the value of a third field. In this case will be set to for a third field.

[tinkerz1]

I think its confusing for and end user to press a button and some selections turn green but not all but a pivot table can produce an output on partial selections.

[ChiragPradhan · Accepted solution]

Use this for each action on State2 button.

=if(Count({<Salesperson={'Mr B'}, Product={'Product 2'}, Country={'Holland'}>} Salesperson) > 0, 'Holland')

[marcus_sommer]

Exactly this is the reason why the use of alternate states or set analysis is difficult for users - you need to explain quite clearly what is happens and why if the select some values and the objects react not like expected. Therefore you should it only use if you it really need and no other way is possible.

- Marcus