Applying Filter to Repeating Group from Radio Buttons

Need help
1

I load a list of records into a RG from the SQL API, not problem. I have radio buttons to allow the user to filter on a field that holds a numeric value (Hours), so they can have the RG only display a subset of the records already displayed in the RG. I have a workflow set for when the value of the Radio Buttons change. I am using the ‘Display List’ workflow and setting the filter for the RG in there, referencing the RG list. But nothing seems to happen. The RG does not refresh and displays the same records no matter what I select in the radio buttons. Any help would be appreciated. Thanks.

image
image887×581 48.1 KB

image
image1464×480 52.3 KB

2

  1. If you’re using your method of displaying data, try having the “reset data” option first.

  2. If I were you, I’d use conditional settings to change the data displayed in the repeating group. Or I’m not sure why you can’t just set the repeating group’s data source to correlate with the Radio Button’s value. Regardless, I’d stay way from using workflows in this scenario.

It’s possible I’m not understanding your problem correctly. Let me know if this helps,
Daniel

3

Hi Daniel
Tried both idea’s, but no luck. Not sure how else to explain the situation though. I thought just adding the filter to the API call would work, but it didn’t. I thought adding the filter to the RG itself (without calling the API again to get the data it already retrieved), would just filter out the records. But still no luck. I think I’m missing some small detail, as it must work. Frustrating. But, thanks.
-David

4

What exactly are you using the Radio Button element for? This will help us get to the root of the problem.

5

I just want the RG to show either:

  1. ‘All’ the records returned from the SQL API call, or
  2. Just records that have one of the fields (in this case the ‘hours’) ‘>0’, or
  3. Just records that have one of the fields (in this case the ‘hours’) =>0’
6

And you can make the data source any 3 of the options listed with no problems? But you just aren’t able to change them once loaded?

If that’s correct, please list the values you have for your Radio Buttons.

7

I call a SQL stored procedure using the SQL API Connector that returns All the records. I thought I could just filter the resultset in Bubble based on the radio button choices. But that did not work. I tried using the :Filter command as I showed in the original post, but that did nothing.

The radio buttons are set up as:
image

8

So only the “All” option works. Hey @emmanuel, is it possible to filter data returned by the SQL Connector?

9

@dbevan thanks for trying to help. Looks like no help from Bubble. Oh well.

10

This topic was automatically closed after 70 days. New replies are no longer allowed.