Action based selection of all value except one . How to achieve ?

[shekhar_analyti]

Hi All ,

Action based selection of all value except one . How to achieve ?

Let say there is a field Company ; whose distinct values keeps updating on daily basis .

Company

A

B

C

D

E

F

....

..........

What i needed was , when user presses a ACTION BUTTON , all values except C should be selected in Company field for 1st time , if the same button is selected for second time , it should return to normal state .

Thanks & Regards

Shekar

[shekhar_analyti]

stalwar1‌

Hi Sunny Bhai . Help Needed !!

[m_woolf]

Can be done with two buttons and a Conditional Show:

First button visible when vToggle = No

Actions to select all but one value:

     First action: Select in Field Company, Select value C

     Second Action: Select Excluded

     Third action Set Variable vToggle = Yes

Second button visible when vToggle = Yes

Actions:

     First Action: Clear Field Company

     Second action: Set variable vToggle = No

[sunny_talwar · Accepted solution]

Try this...

=If(GetSelectedCount(Company) = 0, '(* ^ C)')

Used Stefan's response from the comment section here

Compound Search - demystified

[shekhar_analyti]

Thank you Bhai ..