I am a bit confused on how you can populate a list that is filtered on a specific value that I as the “programmer” has specified.
Here’s the case. I have an Organization that has Users, and those users have a Gender (male or female). Gender is a Data Type.
I want to show a text field that calculates the number of Users that belong to the Gender named “Female”, but I can’t for the life of me figure out where I can specify this particular description. The calculation is working, as when I choose to search for the first item or last item, it returns the correct count. However, that seems like a poor solution, as it would screw up if I added one more gender.
How can I filter it to search only for Employees ––> Gender ––> is “Female”?
In this example, you can just use “Gender = Female” Bubble lets you type plain text in those fields, so as long as your capitalization/spelling is consistent, it’ll work fine.
Logically, what you are trying to ask Bubble is this: Show me every user who is a part of the parent group’s organization, and is a female. In your screenshot above, you are actually asking this: Show me every user is part of the parent group’s organization, and has a gender of whatever is the last entry in my database.
Thank you for the quick reply! I’m still not able to actually type in “Female” in the Constraint. I can only choose Click and make my choice from the dropdown list.
Not noobish at all. Its frustrating at first just start force typing “Female” . Why don’t you do a drop down with (Male, Female,… then just reference the dropdown gender value on this field. This allows for more flexibility
That’s strange. Maybe delete that row on the “Search for Users” panel, then add it again. Then, right after the equals, try to type Female. Sometimes in Bubble, I find that it doesn’t like it when I try to remove dynamic expression and replace it with a hand-typed string, so I end up removing that entry and just doing it again from scratch. It’s only about 15 seconds lost, no biggie in my case.
Thank you both for the input. It simply will not allow me typing in anything for Gender in particular. I even tried in a different browser. However, for any field other than Gender, it’s no problem. (As you can see, I can search for a first name just fine).
After the Gender Recognition Act in the UK, it now possible for a Person to legally have two Genders at the same time, another great conversation with the DBA. Although “What do you mean year is more than two digits !” was also a highlight.
The system is actually prepared to handle more than two genders, as genders is a data type The dashboard would have to change a bit though, and it might be difficult to find a fitting icon for all 33 of them.
Two genders at the same time we would also be able to handle by converting to a list. Bubble might have taken the complexity out of programming – but not out of public policy it would seem. Still, if it makes people happy, I’m all for it
I can type “Female” after clicking Click (and seeing the menu), but it will not accept the term, and reverts back to the red Click as soon as the field loses focus. Pressing enter does nothing.
The dashboard would have to change a bit though, and it might be difficult to find a fitting icon for all 33 of them.
