I’ve been working with Bubble for some time now and most things go wel… However, I am currently stuck on something which should be quite easy to do, but I can’t get my head around it.
Outline:
The app is a a collaboration platform where Users can interact (share files, chat etcetera) in private Communities.
Communities are setup by the Admin, and also each Community as a Moderator (a User).
Where I am stuck is how I can setup the Communiites (add Users, and Moderators), and also how I can change the Users associated with certain Communities, without deleting them (permanently).
Adding users:
So when I setup a new Community, my next step should be adding Users. So I setup a workflow which says "change a list of things’ and then add the user to the List of Users of the designated Community.
For some reason, I can’t make it work. I’ve tried several workflows with the functions ’ Changing a list of things’, or ‘Add something to a list of things’ and I can’t make it work. Can someone please help me with this?
I don’t think that’s the best solution, since it would make my database unnecessary complex. It shouldn’t be two hard to let 2 items interact with each other in Bubble right?
See I think of it as making the complex simple. Generally when there is a “has many” relationship that goes both ways, a relational table is the most elegant solution:
A community has many users.
A user has many communities.
You might be able to do what you want, but I don’t know if it’s best in the long run.
So, how would this datatable be structured then? Because I thought I already had two understanding tables, since every Community has a list of Users, and every User has a list of Communities
Both if I go this way, then this section will be the only part where I can’t manage to let two tables interact with each. Since my User profile also has Education,Profile Information etc. which is shown to the Users based on the different repeating groups… That’s why I’m bothered that regarding the Community/User relation I can’t get things to work…
I would agree with this approach. I’m using something similar in an app I’m working on. Once you add each user and their communities to the third table, searching/filtering the data based on user or community is pretty straight forward… Depending on how you want to display the data.
ok, let me try to explain what I already did. As I said, the aim of the app is to let Users interact (chat/share files) in different Communities. the Communities can be described best as private groups, under the supervision of one Community Moderator (the one who decides let someone to the Community or remove one from the Community).
So, in order to make the connection I have 3 tables. User, Community and Community_user.
Where I am currently stuck is on the ‘admin part’ of the site, where I want to create Communities. So I’ve created a repeating group which shows all the Communities… So far so good… Then within this repeating group, I want to have section where I can add the 'Community Users (general users), and where i can add the Users which will be defined as Moderators…
So, the workflow should be: Search (among all users) and add user), and make this user a community_user of the Community which is showed by the repeating groups. And as a result, the repeating group of community_users, should then reflect this Users name (repeating group: search for users, which are community_users of the parent group community)… And this is what I can’t get to work…
If it sounds to complicated, please have a look at my app:.
The link to my app (Admin_communities page) is Live-app | Bubble Editor
