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
Solved! Go to Solution.
Iโve got the solution!
Thanks to @June_Corpuz !
SELECT( Parts[Name_long], IN( [Category], SPLIT( [_THISROW].[Category], "," ) ) )
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]
)
)
)
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:
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โ.
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.
Iโve got the solution!
Thanks to @June_Corpuz !
SELECT( Parts[Name_long], IN( [Category], SPLIT( [_THISROW].[Category], "," ) ) )
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!
Nevermind! Got it
User | Count |
---|---|
42 | |
33 | |
24 | |
23 | |
14 |