Hi bubble community,
I am trying to display a sorted database, for example I have the following database :
And I can display it with a repeating group as above but I would like to display it like this :
JCST 6 Jarvis
JCST 6 Lise
It means that I would look in my table to only show once the multiple entry with a count of the cumulated number.
I can’t figure how to filter it or make it happen with a repeating group , does any one have an idea ?
You can probably solve this by adding the :unique elements argument to the RG’s Data Source, and adding a text field in the RG’s cell that counts the number of elements that match.
Hi @petter, thank you for your reply.
I am still facing one issue, is that I am looking for Project unique element… so I have only one line for every projects… but I would like to have different lines if the creator is differents…
So for the one who were struggling with the same problem. I set up The repeating group to search for unique element
<img
The first one is the display of my database:slight_smile:
The second one is the Display of my database, with the number of calculated hours per users but I don’t know how to stop the line which are the same. Do you know how I could filtered that ?
I would like to say filter it with the constraint creator <> current cells creator but i cant…
Maybe it would help to nest two Repeating Groups so that one shows Creator and the one inside shows Projects (or the other way around, depending on how you want to sort it).
Thank you @petter that was really helpfull !
But there is still one thing that I don’t understand how to do:
So now I have one repeating group which search my Projects and inside a repating group to find the user of this project. I try to count the number of hours work for every user on One project but can’t do it because I cant access the “current cells project info” while doing a search for in my second repeating group… Do you have any idea how to filter it ?
Put the 2nd repeating group inside a group. Set the group to type = project, source = current cell’s project. The User search can still reference the Parent Group’s Project, and your constraint for this Search for Even Registration can be Project = Group’s Project. Try that.
