Dependent enums in form not working

AppSheet AppSheet Q&A
, ,
1

Hello everyone,

I am using a table “Types” which has the following structure.

type_id type_name type_group
1 type 1 group 1
2 type 2 group 2
3 type 3 group 2

I am using a form in another table “Cases” where I have two columns, both of the type = Enum (base type = text):

  • case_type_group
    configured with Valid If: Types[type_group]
  • case_type_name
    configured with Valid If: Types[type_name]

When using the form, to create a new case, I

  1. first want to choose the case_type_group
  2. and show the case_type_name-options depending on the case_type_group-selection

Unfortunately, the case_type_group doesn’t show up in the form at the beginning. Only the case_type_name shows up. As soon as I choose a case_type_name, the matching case_type_group appears. (I choose "type 2, and group 2 shows up).
I want to have it the opposite way. (I want to choose group 2, and type 2 & type 3 should appear) How can I achieve that?

Thanks in advance!

2

Hi @jonasjonas

You probably have the answer here:

Dependent drop-downs - AppSheet Help

Drop-down from Valid_If - AppSheet Help

Drop-down on a Ref column - AppSheet Help

The solution would probably be:

SELECT(Types[type_name],
  [type_group]=[_THISROW].[case_type_group]
)

For reference:

SELECT() - AppSheet Help

2 Likes
3

Thank you very much.

2 Likes
4

You are welcome !

1 Like