I am relatively new to bubble and seem to have hit a wall in my learnings. I spent all day trying to create what I thought would be a simple connecting of two data types (or things)
Thing 1: Project (this database entry is just a title input)
Thing 2: Team (this database entry has multiple data entries - name, description, etc)
What I am trying to do…
Display the Project Titles in a RG >> place a button in the RG next to the title>> the button shows the information about the Team (ONLY associated with that cell in the RG, not all of the teams in the database)
One group creates the Project with an add project button
Another group creates the Team and assigns a Project from a dynamic drop-down
Upon clicking the [create team] button I have tried to connect the two data types by creating a new Project as well in the workflow.
I know this question has been answered in other forms on the forum but I can’t seem to find anything that has worked thus far.
@cmarchan thanks for your help but not what I was looking for. This looks like a one-to-many database structure.
Looking for how to handle a many-to-many relationship as it would be called in traditional database architecture. Bubble says it supports this, I have seen use cases explained, but nothing around the web to show a concrete tutorial (for a beginner) on the workflows besides @TipLister who did an example but doesn’t quite fit my scenario and was a little difficult to follow.
Anyone who can explain either option 1, 2, or 3 (probably the best for scaling) in practice and not theory from the bubble manual it would be greatly appreciated!
A “team” has a “project” and a list of members (“users”)
Everything in “” is a data type
And below are two repeating groups of 1 row and 1 column each, displaying a project’s title or a team’s title. The first rg is searching for teams and the second one is searching for projects. I show them like this for illustrative purposes only:
