EnumList - The list depends on the selected values

[Pepe]

Hello World!

I have a problem that, unfortunately, I cannot solve.
I have a table (“PARTS”) with 4 columns (Category; ID; Name; Name_long).
I want to create a form in which, after selecting a specific category, I will see a pool of names assigned to the selected category. The problem is that I would like the user to be able to choose e.g. 3 categories at the same time, and then in the next step he would get answers from 3 selected categories.

Is such a solution possible?
I am asking for help and thank you in advance

eg.:

Category:
wheels ( 20", 21", 22" )
steering wheels ( black, yellow, white )
engines ( 16V, 8V )

User chooses 2 categories ( wheels and engines ), and in the next step he can choose only 20", 21", 22", 16V, 8V.

I hope that I managed to explain it quite clearly

[JuneCorpuz]

Hello-

Welcome to AppSheet community!

Please try this formula. Let me know if you encountered any errors.

SELECT(
	Parts[ID],
	IN(
		[Category],
		SPLIT(
			[_THISROW].[Category]
		)
	)
)

[Pepe]

Thank you for your response! Unfortunately, the solution you provided does not work (or I am doing something wrong with it).

I will try to detail what I mean:

1. I have one file with two tables: “Arkusz1” (eng. “Sheet1”) and “PARTS”. The “Arkusz 1” tab is my main table where I would like to get all the responses from the form. The “PARTS” tab is actually just a parts list.

2. The “Arkusz 1” table looks like this:

I would like selected parts from the list in the “PARTS” table to appear in the “Wymienione części na nowe” (eng. “Replaced parts for new”) column in “Arkusz 1”.

3. The “PARTS” table looks like this:

4. The form looks like this:

I would like that in the field “Wymienione części na nowe” you select categories first (from the “Category” column in the “PARTS” tab), then specific parts from the selected categories (from the “Name_long” column, also from the PARTS tab) appear.

[Pepe · Accepted solution]

I’ve got the solution!

Thanks to @June_Corpuz !

SELECT(
	Parts[Name_long],
	IN(
		[Category],
		SPLIT(
			[_THISROW].[Category],
            ","
		)
	)
)

[Pepe]

Hello back!

It’s time for a little update. I am currently struggling to add one more condition (the output column) to my form.

The thing is, the user would first select a type (“Typ_Roweru” column), then a category (“Kateogira” column), and finally a specific part (“Name_long” column).

My guess is that you need to add something to the previous code, but I’ve tried many things and it doesn’t work :(.

Please help!

[Pepe]

Nevermind! Got it