0 Favourites

How do I create a filter app using lists

  • 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!!!!

  • Construct 3

    Buy Construct 3

    Develop games in your browser. Powerful, performant & highly capable.

    Buy Now Construct 3 users don't see these ads
  • 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.

Jump to:
Active Users
There are 1 visitors browsing this topic (0 users and 1 guests)
Similar Topics Posts Views Last Post
Unread sticky
203 458,173
Kyatric's avatar
Kyatric Construct Team Support
Unread hot topic
173 28,546
Rich's avatar
Rich
Unread hot topic
0 Favourites
My ongoing list
133 6,080
thomasmahler's avatar
thomasmahler