show some values in a column enum type

AppSheet AppSheet Q&A
1

hi

What strategy can I use so that in a form view, an enum type column only shows some values, depending on the value entered in the previous column?

thanks

2

Use a Valid if expression to generate a list of the appropriate values.

See Drop-down from Valid_If

3 
Hi Steve
Thank you for your response, but the examples do not fit my needs, I explain:

I have the column [operations], with the values: income, payments, investments.

The next column [source of funds], also enum type, has the following values: bna, bbva, ppi, cash, chu....

I wish that if the investments option is chosen, only the options are shown: ppi and chu
4

Something like this?

SWITCH(
  [operations],
  "investments",
    {"ppi", "chu"},
  {"bna", "bbva", "ppi", "cash", "chu", ...}
)
3 Likes