topic Sheet Action Select Values in a Field in App Development

Sheet Action Select Values in a Field

justalkak — Wed, 30 Apr 2025 08:59:42 GMT

Hi,

I need to create a sheet action on sheet1 on FieldA where the values of FieldA1 from another sheet will be selected.

I have achieved it by setting the following Actions:

1. Select values in a field - on a FieldA - with function: Concat(distinct FieldA1, ';')

2. Clearing selections in FieldA1

This works, however when no FieldA1 is selected it filters for ALL FieldA options when moving to sheet1.

How can I make it not select All FieldA options when no FieldA1 is selected?

I have tried this but it won't work.. If(GetSelectedCount(FieldA1)>0, Concat(distinct FieldA1, ';'))

henrikalmen — Wed, 30 Apr 2025 09:09:41 GMT

Are all values actually selected in FieldA, or are no values selected so that all values are implicitly available?

justalkak — Wed, 30 Apr 2025 10:38:05 GMT

No values are selected in FieldA1. Then when changing the sheet All values are selected by the action on FieldA.