How do I create a filter app using lists

Get help using Construct 2

Post » Wed Dec 03, 2014 8:01 pm

So I'm trying to do something fairly complex but hopefully one of you geniuses out there can solve it in 2 seconds.
I'm going to try and be as specific as I can to help you out.

I want to create a filter using lists to narrow down the number of results.

User selects from 4 lists different selection criteria. These are the 4 lists.
1. Color; red;green;blue
2. size; small;medium;large
3. Material;cotton;silk;leather
4. Style;vintage;current;modern

based on their selections, lets say... red small cotton and modern
it would generate a list, could be just one or multiple, of items that fit that description.
it would be drawing from a database of multiple items

to continue, when a user clicks the button find my items it generates a list that would have three columns
Designer, ID Number, and Location.

Like i said there could be multiple items or just one that fit the LIST criteria selected by the user.

ALSO and this is important, if a user doesn't select a list like leaves style blank, i want the list to populate all items that are tagged with either vintage, current, or modern.

I'm open to using JSON to import a list from excel or any method.
The thing i really need to know how to filter a list in a way that can return multiple items.


For one more visual.

Color: Red
Size: Small
Material: Blank
Style: Vintage

[FIND MY ITEMS]

Designer | ID Number | Location |
Joes | 383030 | Store 3 |
Johns | 345454 | Store 1 |
Hudson | 385353 | Store 5 |
AA | 353550 | Store 3 |


THANK YOU SO MUCH!!!!
B
4
Posts: 20
Reputation: 240

Post » Wed Dec 10, 2014 8:00 pm

Well I gave it a shot. Creating the array should be done with JSON to be doable. Not by hand like I did.

If you choose all top options, you will get 2 results, all second options and you get 1 result, all 3rd options and you also get 1 result. Everything else gives 0 results. But the mechanic works.

If you could by any means filter these beforehand when querying the database, that would be better.



Should you have more questions, about the capx or other. I'll be glad to answer them for you.
You do not have the required permissions to view the files attached to this post.
B
18
S
6
G
3
Posts: 30
Reputation: 4,208


Return to How do I....?

Who is online

Users browsing this forum: Cubeeo and 22 guests