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):
When using the form, to create a new case, I
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!
Solved! Go to Solution.
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:
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:
Thank you very much.
You are welcome !
User | Count |
---|---|
43 | |
28 | |
23 | |
14 | |
14 |