Button Toggel Selections

[brf10043]

Guys,

I am trying to use a button to toggle between a selection of [IM Submitter RA] = 'GSK-SERVICEDESK-APAC' and 'GSK-SERVICEDESK'

I can us the code below with one value at a time, can work out how to toggle between both values and no values. 

I've tried something like this, but obviously, that doesn't work.

=If(GetFieldSelections([IM Submitter RA])='GSK-SERVICEDESK-APAC', '<> GSK-SERVICEDESK-APAC', 'GSK-SERVICEDESK-APAC')

and

If(GetFieldSelections([IM Submitter RA])='GSK-SERVICEDESK', '<> GSK-SERVICEDESK', 'GSK-SERVICEDESK')

[sunny_talwar]

I am not entirely sure I understand what you are trying to do... would you be able to share a mocked up sample to show what you have and what you are looking to do?

[brf10043]

I can't really share the app at the moment.  However, what I'm trying to do is pretty simple.

In my data I have many different values in a column called IM Submitter RA.  I'm trying to create a button that toggles between all values in the IM Submitter RA column and 2 specific values ('GSK-SERVICEDESK-APAC' and 'GSK-SERVICEDESK').

I have the following code working but for only 1 RA.

=If(GetFieldSelections([IM Submitter RA])='GSK-SERVICEDESK-APAC', '<> GSK-SERVICEDESK-APAC', 'GSK-SERVICEDESK-APAC')

I'm looking for code where I can toggle between selecting two values in the same column or all values in the column.

[settu_periasamy · Accepted solution]

Not sure understand properly.

May be like this?

Add Two "Toggle Select" Actions.

Put the Same Field in the both with different values.

like the below

[trdandamudi]

One way is as below:

For your toggle button you can add a select in field like below: (vToggle is a variable)

Select in Field:

Field:

      Country

Search String:

     =If(vToggle=1,'("Europe"|"America")','*')

The above code, on one click it will select the data for Europe and America and the other click it selects all the data for a particular column. Hope this helps..