Dependent dropDrown using valid if

[fauzan_skywalke]

HI GUYS

I’m a beginner in appsheets

I want to ask as a beginner …

I made dependent dropdowns using valid if with the state and city columns and its works. but I can only choose one option in the country column, how can I choose 2 or more choices in the country column. is it possible guys? …
thanks in advance

[GreenFlux]

Change the column type of Country to EnumList.

[fauzan_skywalke]

it’s doesn’t work…

[GreenFlux]

If you don’t provide the values directly (as shown here), then you must enable Allow other values.

Try changing it back to EnumList and turn on Allow other values.

[fauzan_skywalke]

thanks for the answer bro… but it doesn’t work because maybe you haven’t understood my question yet… cause I just took the example of the parable in the question above

this is a valid if display in my application

if I select “A” in the COLOUM GROUP it will appear in the CABLE UP data coloum from group A cable up (based on the validation data in my spreadsheet image), then if I select one of the CABLE UP coloum options then the NH FUSE coloum will appear ( picture 3)…

my question is
first: how can I make more than 1 choice in the GROUP column, and the data in the CABLE UP column follows the choices in GARDU.

second: (image 4)
how to order in the NH FUSE column the data that appears matches the spreadsheet based on the GROUP selection

hope you can understand my question, and can provide a solution about it…

thanks…

[Steve]

fauzan_skywalker:

but it doesn’t work because maybe you haven’t understood my question yet…

So you asked a question that has nothing to do with what you really want? Why did you choose to be difficult?

[fauzan_skywalke]

yeahh sorry; D I can’t explain my question well so I try with a question that is easier for me to explain and hope to get a little picture of the answer, but it doesn’t work.

[Steve]

I’m guessing you want the user to select a group, then for CABLE UP, CABLE DOWN, and NH FUSE to only show values associated with the chosen group?

[fauzan_skywalke]

Yes exactly… what can i do for it ?

[Steve]

Set the Valid If for the CABLE UP column to the following:

SELECT(
  GARDU[CABLE UP],
  ([_THISROW].[GROUP] = [GROUP])
)

For NH FUSE, should all values for the chosen group be shown, or only those are match both the group and the CABLE UP value?

[fauzan_skywalke]

Steve:

SELECT(
  GARDU[CABLE UP],
  ([_THISROW].[GROUP] = [GROUP])
)

yes for NH FUSE all values must be shown

[Steve]

Then for the Valid If expression for NH FUSE, try this:

SELECT(
  GARDU[NH FUSE],
  ([_THISROW].[GROUP] = [GROUP])
)

[fauzan_skywalke]

Thanks it’s works… one more question is it possible in the group column I chose more than one choice ?

[Steve · Accepted solution]

fauzan_skywalker:

is it possible in the group column I chose more than one choice ?

Yes. @GreenFlux already answered that question. You will then need to change the Valid If expressions I gave as follows:

CABLE UP:

SELECT(
  GARDU[CABLE UP],
  IN([_THISROW].[GROUP], [GROUP])
)

NH FUSE:

SELECT(
  GARDU[NH FUSE],
  IN([_THISROW].[GROUP], [GROUP])
)

[fauzan_skywalke]

Thank you so much guys @Steve @GreenFlux it’s works

[llheath]

Steve:

SELECT(
  GARDU[CABLE UP],
  ([_THISROW].[GROUP] = [GROUP])
)

Is there a way to add…if the entries in a restricted dropdown are shown can you have an +?

[Steve]

I don’t understand your question.

[llheath]

I can get the drop down to work, but can if the users wants to add an entry instead of picking one is that possible? The table I am referencing does have adds allowed

[Steve]

Try using Suggested Values instead of Valid If.

[Steve]

What is “GARDU”?

What does “follow the choices” mean? There are several ways to interpret that.

What does “order in the NH FUSE column the data that appears matches the spreadsheet” mean? Again, I can imagine several interpretations.