# Multiple filter popup to filter repeating group display \[solved\] **URL:** \ **Category:** Need help\ **Created:** [November 17, 2018, 7:27am UTC](https://forum.bubble.io/t/multiple-filter-popup-to-filter-repeating-group-display-solved/42585 "2018-11-17T07:27:47Z")\ **Posts on this page:** 16\ **Page:** 1
**Author:** ![acap](https://sea1.discourse-cdn.com/bubble/user_avatar/forum.bubble.io/acap/32/31821_2.png) [@acap](https://forum.bubble.io/u/acap)\ **Post date:** [November 17, 2018, 7:27am UTC](https://forum.bubble.io/t/multiple-filter-popup-to-filter-repeating-group-display-solved/42585/1 "2018-11-17T07:27:48Z")
i have a multiple input to capture as filter to my display. the input for my filter is in popup form. however, i can only filter the right way if i only put one input. if i put more than 1, it wont filter my display according to the multiple input that i key in to filter. as fir now i am using a condition method to filter but it is not working ![32%20PM](https://us1.discourse-cdn.com/bubble/original/3X/c/1/c17e4b88eaa02f03c45f5c17f3ba6283878591a8.png) this is the display ![56%20PM](https://us1.discourse-cdn.com/bubble/original/3X/6/9/693dec771064fa13700361bb47ca3b191c0f8881.png) this is the popup to filter my display ![22%20PM](https://us1.discourse-cdn.com/bubble/original/3X/5/1/51ffeb1b272b110ac5f3ebf73a5f32320222b4b6.png) this is the current method that im using to filter my display. is there any solution to this??? ---
**Author:** ![acap](https://sea1.discourse-cdn.com/bubble/user_avatar/forum.bubble.io/acap/32/31821_2.png) [@acap](https://forum.bubble.io/u/acap)\ **Post date:** [November 17, 2018, 7:29am UTC](https://forum.bubble.io/t/multiple-filter-popup-to-filter-repeating-group-display-solved/42585/2 "2018-11-17T07:29:19Z")
what im trying to do here is to make my display all the filter that i key in on the popup at once. multi filter. ---
**Author:** ![acap](https://sea1.discourse-cdn.com/bubble/user_avatar/forum.bubble.io/acap/32/31821_2.png) [@acap](https://forum.bubble.io/u/acap)\ **Post date:** [November 17, 2018, 11:57am UTC](https://forum.bubble.io/t/multiple-filter-popup-to-filter-repeating-group-display-solved/42585/4 "2018-11-17T11:57:46Z")
@fayewatson can you help me out? ---
**Author:** ![fayewatson](https://sea1.discourse-cdn.com/bubble/user_avatar/forum.bubble.io/fayewatson/32/2686_2.png) [@fayewatson](https://forum.bubble.io/u/fayewatson)\ **Post date:** [November 17, 2018, 10:44pm UTC](https://forum.bubble.io/t/multiple-filter-popup-to-filter-repeating-group-display-solved/42585/5 "2018-11-17T22:44:30Z")
Hi @acap šŸ™‚ Just to double-check, four of those filters are referring to Max Price, Seller, Distance, Date ā€“ what are the other two? And the filters you need can only be dropdowns or you might use inputs and range elements as well? \*Also, what are the sorting options? ---
**Author:** ![keith](https://sea1.discourse-cdn.com/bubble/user_avatar/forum.bubble.io/keith/32/56020_2.png) [@keith](https://forum.bubble.io/u/keith)\ **Post date:** [November 17, 2018, 10:50pm UTC](https://forum.bubble.io/t/multiple-filter-popup-to-filter-repeating-group-display-solved/42585/6 "2018-11-17T22:50:26Z")
You donā€™t need a condition for every value in the dropdown. You simply USE THE DROPDOWNā€™s value in your search expression. Just as you would do with any other input. ---
**Author:** ![acap](https://sea1.discourse-cdn.com/bubble/user_avatar/forum.bubble.io/acap/32/31821_2.png) [@acap](https://forum.bubble.io/u/acap)\ **Post date:** [November 18, 2018, 3:27am UTC](https://forum.bubble.io/t/multiple-filter-popup-to-filter-repeating-group-display-solved/42585/7 "2018-11-18T03:27:10Z")
@fayewatson its date and type. the max price and distance is in number format and date is in date format harga max = max price (number) orang sebilik = people / room (text because no calculation needed. just display) penerbangang = airline (text) jarak maximum - max distance (number) tarikh = date (date) jenis umrah = type (text) ---
**Author:** ![acap](https://sea1.discourse-cdn.com/bubble/user_avatar/forum.bubble.io/acap/32/31821_2.png) [@acap](https://forum.bubble.io/u/acap)\ **Post date:** [November 18, 2018, 3:32am UTC](https://forum.bubble.io/t/multiple-filter-popup-to-filter-repeating-group-display-solved/42585/8 "2018-11-18T03:32:09Z")
@keith but i want the repeating cell to show all the data if there is no value in those drop down. what do u mean by search expression? ---
**Author:** ![keith](https://sea1.discourse-cdn.com/bubble/user_avatar/forum.bubble.io/keith/32/56020_2.png) [@keith](https://forum.bubble.io/u/keith)\ **Post date:** [November 18, 2018, 3:48am UTC](https://forum.bubble.io/t/multiple-filter-popup-to-filter-repeating-group-display-solved/42585/9 "2018-11-18T03:48:45Z")
Click the box for ā€œignore empty constraintsā€. Now instead of matching ā€œnullā€, your search will disregard the constraint and show all values. As for what a search expression isā€¦ THIS is a search expression (circled in red): ![image](https://us1.discourse-cdn.com/bubble/original/3X/6/5/65e0a81807a47b41ee85c8885db7b02460dd835f.jpeg) You have a separate condition for each and every value of the dropdown. This makes no sense. What you want to do is simply have ONE search expression and move the value of the dropdown to the constraint. Like so: ![image](https://us1.discourse-cdn.com/bubble/original/3X/8/c/8cfc7f5738298db3bbdec2ae7141dce21a0470fe.jpeg) ---
**Author:** ![acap](https://sea1.discourse-cdn.com/bubble/user_avatar/forum.bubble.io/acap/32/31821_2.png) [@acap](https://forum.bubble.io/u/acap)\ **Post date:** [November 18, 2018, 4:16am UTC](https://forum.bubble.io/t/multiple-filter-popup-to-filter-repeating-group-display-solved/42585/10 "2018-11-18T04:16:37Z")
@keith ive tried doing that. the reason is the dropdown value is a static choice. hence, cant be read as number. and for the last choice in max hargaā€™s dropdown value is above 16,000. ive created database for those choices so that i can use a dynamic choice. but i cant figure-out the above 16,000 part with this method. this is the choice: 5000 6000 7000 8000 9000 10,000 12,000 15,000 Above 16,000 ---
**Author:** ![fayewatson](https://sea1.discourse-cdn.com/bubble/user_avatar/forum.bubble.io/fayewatson/32/2686_2.png) [@fayewatson](https://forum.bubble.io/u/fayewatson)\ **Post date:** [November 18, 2018, 4:51am UTC](https://forum.bubble.io/t/multiple-filter-popup-to-filter-repeating-group-display-solved/42585/11 "2018-11-18T04:51:24Z")
@acap Is this example along the lines of what you trying to set up? Preview: > **[Bubble - Visual Programming](https://faye-demo-app.bubbleapps.io/version-test/dropdown-filters)** > > Build stuff without code and launch a startup without a tech-cofounder! Bubble is a visual programing language. Instead of typing code, use a visual editor to build applications. Editor: > **[Bubble Editor - faye-demo-app](https://bubble.io/page?type=page&name=dropdown-filters&id=faye-demo-app&tab=tabs-1)** > > Build stuff without code and launch a startup without a tech-cofounder! Bubble is a visual programing language. Instead of typing code, use a visual editor to build applications. If so, there is just a minor workaround for the Max Price dropdown. The dropdown that the User sees is setup in the way you have it: ![image](https://us1.discourse-cdn.com/bubble/original/3X/8/5/85f2443256d578495e3c88c974eab9a55b9984e3.png) Since the last option contains a text ā€œAbove 16,000ā€, we can use a transparent input which removes that text when filtering the results. In the corner of the popup there is an element called ā€œInput Max Price (Transparent)ā€: ![InputMaxPrice](https://us1.discourse-cdn.com/bubble/original/3X/1/8/18dbc7aabd4d3b245ee8346e1f045f68f213bde5.png) \*The transparent inputā€™s value is ā€œDropdown Max Priceā€'s value:find&replace (the find and replace part removes the ā€œAboveā€ text, so the transparent input only contains 16,000 when that option is selected). Edit: After reading Keithā€™s post, I realize that this should instead replace"Above 16,000" to empty, since Above 16,000 equals ā€œNo Max Priceā€. This way, the Max Price constraint will be ignored if the User selects ā€œNo Max Priceā€ ![image](https://us1.discourse-cdn.com/bubble/original/3X/a/8/a8d04ee35932558c294e0d2bc725a3470950ace5.png) This way, the repeating group just uses the Number value from the transparent input: ![InputTransparentFilter](https://us1.discourse-cdn.com/bubble/original/3X/5/f/5fa57b4a9dd8cf85a6b2b70d0a0bc4630e5ae6b8.png) The last option makes sure that the repeating group sort changes. By default, the items are sorted by ā€œDateā€: ![SortByDate](https://us1.discourse-cdn.com/bubble/original/3X/6/1/61f4a4c3cb5770fa4cadfcad7b065dd62848cb08.png) Then there is one conditional statement which sorts the results by Type when the Dropdown Sort By value is ā€œTypeā€: ![SortByType](https://us1.discourse-cdn.com/bubble/original/3X/6/e/6eebf8173e8429abfd2ffdd5a8aee278733793ed.png) As @keith stated, youā€™ll want to select ā€˜Ignore Empty Constraintsā€™ for the data searches. This is because the User may not fill out all of the filter options. For the options they donā€™t select a filter for, Bubble will ā€˜ignoreā€™ that constraint/filter. šŸ™‚ ---
**Author:** ![keith](https://sea1.discourse-cdn.com/bubble/user_avatar/forum.bubble.io/keith/32/56020_2.png) [@keith](https://forum.bubble.io/u/keith)\ **Post date:** [November 18, 2018, 5:07am UTC](https://forum.bubble.io/t/multiple-filter-popup-to-filter-repeating-group-display-solved/42585/12 "2018-11-18T05:07:54Z")
You were very close to having that all figured out! You just need to make your database object a little bit fancierā€¦ Read on: There are two things you should do here. First, as you point out, not all of your dropdown choices are numeric. So, instead of having a list of mixed type in your database (which of course you canā€™t have), you create a custom object, like: `Harga Dropdown Option` A Harga Dropdown Option should have TWO fields on it: The Displayed **`Caption`** (data type text) and **`Value`** (data type number). Now you can either make a new data type called Harga Dropdown Option **S** (see what I did there?) and give it a field that is of type Harga Dropdown Option (and make that a list), or just ā€œDo a search forā€¦ Harga Dropdown Optionā€ and sort them the right way (sort on Value, ascending) to get your dynamic dropdown source. Now your dropdown selects a thing of Harga Dropdown Option type. What a weird thing to select, right? Itā€™s neither a text nor a number. Itā€™s just a Harga Dropdown Option. BUT, the Harga Dropdown Optionā€™s Caption is a text. And the Harga Dropdown Optionā€™s Value is a number. Cool! So nowā€¦ For the dropdownā€™s caption field, just use `Harga Dropdown Option's Caption`. The numeric value associated with that selected object is now the `Harga Dropdown Option's Value` (and thatā€™s what youā€™d use in your Search constraint). Now, the second thing: [Edit: Removed confusing sentence.] If Iā€™m not mistaken, when ā€œAbove 16,000ā€ is selected, thatā€™s the same thing as not having a constraint, right? So you can make THAT Harga Dropdown Optionā€™s `Value` field nothing (empty, which is the null value in Bubble). ---
**Author:** ![acap](https://sea1.discourse-cdn.com/bubble/user_avatar/forum.bubble.io/acap/32/31821_2.png) [@acap](https://forum.bubble.io/u/acap)\ **Post date:** [November 18, 2018, 6:34am UTC](https://forum.bubble.io/t/multiple-filter-popup-to-filter-repeating-group-display-solved/42585/13 "2018-11-18T06:34:10Z")
so just to make it clear, i should use constraint on package data source on the repeating group and constraint it base on the values of the dropdown on filter popup instead of using conditional? Iā€™ll give it a try and will update both of u wonderful people! ---
**Author:** ![fayewatson](https://sea1.discourse-cdn.com/bubble/user_avatar/forum.bubble.io/fayewatson/32/2686_2.png) [@fayewatson](https://forum.bubble.io/u/fayewatson)\ **Post date:** [November 18, 2018, 6:40am UTC](https://forum.bubble.io/t/multiple-filter-popup-to-filter-repeating-group-display-solved/42585/14 "2018-11-18T06:40:51Z")
@acap Right! šŸ™‚ Instead of listing each possible dropdown value as a conditional statement, you can use the inputsā€™ values in the constraint, and Bubble will automatically update the results that match the constraints/input values: ![image](https://us1.discourse-cdn.com/bubble/original/3X/2/5/25e8160b8b934786c26b21de3378a385336566a9.png) For example, if the User selected ā€œJetBlueā€ as the Airline, and Max Price = 5,000, the constraints would dynamically become ā€œAirline = Dropdown Airlineā€™s value [JetBlue]ā€ and ā€œPrice \< Input Max Price (Transparent)'s value [5,000]ā€ automatically. Bubble would show all Packages with the JetBlue airline, below 5,000. šŸ™‚ ---
**Author:** ![keith](https://sea1.discourse-cdn.com/bubble/user_avatar/forum.bubble.io/keith/32/56020_2.png) [@keith](https://forum.bubble.io/u/keith)\ **Post date:** [November 18, 2018, 6:47am UTC](https://forum.bubble.io/t/multiple-filter-popup-to-filter-repeating-group-display-solved/42585/15 "2018-11-18T06:47:21Z")
^^^ Yep. (Though note that I would do the dropdown part differently than Faye did ā€“ itā€™s very clever to pass the text dropdown to another input for conversion, but why do that when you can just construct your dropdown options properly in the first place? I would argue that my solution is more ā€œBubble-likeā€ - it takes advantage of the flexible data structures in Bubble, more performant, AND easier to maintainā€¦ Note that you can change the dropdown values at any time, either programmatically or manually, _without_ even having to update the app. Simply modifying the Harga Dropdown Values in your database will magically make the dropdown change.) ---
**Author:** ![acap](https://sea1.discourse-cdn.com/bubble/user_avatar/forum.bubble.io/acap/32/31821_2.png) [@acap](https://forum.bubble.io/u/acap)\ **Post date:** [November 18, 2018, 6:59am UTC](https://forum.bubble.io/t/multiple-filter-popup-to-filter-repeating-group-display-solved/42585/16 "2018-11-18T06:59:15Z")
IT WORKED!!! iā€™ve spent the whole day yesterday trying to figure this out. thank you so much!!! will let you know if there is any problem in the future if thats alright šŸ˜› ---
**Author:** ![system](https://us1.discourse-cdn.com/bubble/original/3X/2/8/2847faa74692c2ffa5d939d3dc3724cdd060d247.png) [@system](https://forum.bubble.io/u/system)\ **Post date:** [January 26, 2019, 7:27am UTC](https://forum.bubble.io/t/multiple-filter-popup-to-filter-repeating-group-display-solved/42585/17 "2019-01-26T07:27:48Z")
Closed on January 26, 2019, 7:27am UTC This topic was automatically closed after 70 days. New replies are no longer allowed.