I read article about "slice based on user inp...

expressions
(tsuji koichi) #1

I read article about “slice based on user input” (https://www.appsheet.com/samples/dynamic-slice?appGuidString=91266cff-e843-46b8-a42b-3d85afedb37f) and it is working with my app, which is great.

What i m trying to do now is to let the user to select multiple items rather than one option from the drop-down list and chart dynamically change and show the selected items.

I want to use “ref” type for the selection columns rather than setting up column as enum nor enum list so that the selecting options works dynamically as well.

I thought contain() expression might solve, but it did not work out.

Is this possible?

(Praveen Seshadri (AppSheet)) #2

Please try using an EnumList type, AllowOtherValues set to true, and then provide a Valid_If condition to provide a list of allowed values.

(tsuji koichi) #3

Thank you Praveen for your advice. However, I wish to set column type to Ref instead of EnumList in order to make the drop down list dynamically change. (Reference table to pull out the drop down list is using Spreadsheet function of Unique(), which is Google Sheet function to get the unique values of the referred column on particular table.

Ref is allowing user to select one item from the list. So it looks to me it is not possible for now to let the user to select multiple items (action like EnumList) from ref type column to dynamically change the chart view?

(Praveen Seshadri (AppSheet)) #4

Right — if you want to select multiple things, it will need to be an EnumList.

This has nothing to do with dynamic or not dynamic. You can use an EnumList with a Valid_If condition where the Valid_if condition provides the dynamic list of allowed values.