Forum Academy Marketplace Showcase Pricing Features

Sort / Filter Repeating Group by Repeating Group Data

Hoping someone can point me in the right direction, please see screenshot below

I have an input and button I’m saving the text input into a data type field called filter name which is displayed in the first RG (Hershey, M&Ms and Kitkat).

How would I go about sorting the 2nd RG based on what’s in the first RG?
For example Susan has Hershey and M&Ms in her list of Candy.

Populating the first RG is done.
I tired populating the 2nd RG by Doing Search For with :filters, etc… but nothing seems to work, any suggestions I could try?

Are you hoping to click on the filters in the first repeating group and then only show users who have that filter in their candy-list?

Hi @williamtisdale
The end user types in the text for filter they are searching for then after clicking the button it goes into the first repeating group and I wanted to somehow sort the second repeating group based on that list of items.

I don’t know if this is possible?

If they were clicking in the first RG I could probably do Display data from that group to the other repeating group (kind of like a popup), so maybe I can also do this in the button workflow after the button is clicked (be back soon)…

Edit: I guess that’s not an option(I couldn’t get access to the 2nd RG this way, I even tried creating a custom state to possibly pass the information that way without much luck). back to the drawing board :slight_smile:

I think I understand. So in your original example in the image you would not want Susan to show because she does not have kitkat? If so, this is possible and I wouldn’t mind building an example but I just want to be clear on the objective.

Hi @williamtisdale,

Thats correct (she would show up after Hershey and M&Ms are entered but once Kikat is entered she would no longer be on the list). That would be amazing of you to take the time to build an example and greatly appreciated! Thank you so much, its awesome of you to share your knowledge (I’ll do the same as I learn more).