What is the constraint or search parameter I should put on a RG data source search that would be equivalent to –
Search Item “X” and display the list of values found in column “Y”. If the same data value appears in column “Y” multiple times, show only one instance of it on the list.
How can I accomplish that?
If you only need the Y, you can do the following:
Search for X : each item's Y : unique elements.
Of course in this case, you need to change the type of the repeating group to Y.
I hope this helps.
@Huseyin from Flusk | Discover the #1 Security and Monitoring Tool for Bubble
Thanks for the reply. I realize in my effort to keep things simple, I oversimplified the situation and left out some helpful details. If you’ll allow me, let me try again–
I’m tracking a list of “awards”…every time a person earns an award, the award gets logged as an item with the season (Sping, Summer, etc) saved as a data field, and the year (2022, 2023, etc) saved as another data field. What I’d like is to generate an RG list of every season/year combo where the person earned at least one award. For clarification, people can earn multiple awards in a season. I have the RG set up to search the awards items and filter by person, but it is displaying each award in the list so I am getting several instances of duplicate season/year combos.
With additional info, could you offer a solution to limit the display of a season/year combo to only once? Thanks!
Search for Awards grouped by year
In each year cell, another RG with data source Search for Awards for Current cell’s year :grouped by season
You can optimise this to avoid multiple searches per cell etc and save a bit of WU but this should send you in the right direction.
