By using "Select in field" trigger,trying to exclude some values

[anshulsri]

Hi All,

I have requirement like:

I have a button in the app. We have a trigger "Select in field" in it. The field which is getting selected has 100s of records. On clicking of button all the values except 5-6 values should be selected. My idea is we can't give these many values in the trigger so we have to write some expression for the excluded values.

Please help me in implementing this requirement.

Many thanks

[jonathandienst · Accepted solution]

AFAIK, you need to do this in two steps - the first to "Select  in Field" the items to be excluded; the second a "Select Excluded" action to invert the selection.

[anshulsri]

Thanks Jonathan,This works absolutely fine.