How to share DB

Hi guys, I have a question and I need your help. I am not able to solve it.

Currently I have two databases, one for users and the other for items, and what I need for the app is that, for example, user 1 can share his items database with another user, I don’t know if I explain myself very well, for example , that several users can edit and manipulate the other’s database, such as a shopping list.

From the top of my head:
In the item collection you can create a new field called Shares. This field should be a many to many relationship to users.
What you can do is on the item page there should be a share button, once clicked on the button you should see a list of users with whom you want to share it.
Once clicked on a user in the list a function should be triggered, which should add the clicked user to the shared field of this current item.

1 Like

Hello, thanks for your help, although I do not understand very well what you are saying, I am quite a newbie.

In summary what I need is that the list created by the user can share it with another user and that the other user can see and edit it.

any idea to carry it out?

I need help please, I can’t solve it.

Thank you.

Some Adalo expert can help me please.

Thank you!

For this I would have 3 collections.

  1. Users
  2. Lists
  3. Items

The ‘Lists’ table is the join table so you need to add a relationship to ‘Users’ and to ‘Items’.

Then setup the relationships so that the Lists collection can have more than one User and more than one item.

To share you then just create an input field and a button that edits the list and adds the input field email user to the user list

1 Like

Ok, I think I almost have it, now I just need to be able to enter the email with whom I want to share my list but I can’t.

I don’t know what action to put on the button to add the email to the owners of a list.

You need to add a relationship from your lists collection to your users collection and set the list to have more than one user. Then the action would be to update a list and add a user to the list of users, not create a list, because your list already exists

1 Like

Hello crmorris2, this is how I have the relationship between users and lists, but when I give the update action I don’t get the option I need, for example to add the user’s email from an input.

image

I have just tested that with a selection menu + a button that allows me to update the logged in user to add any of the lists that appear in the selection menu. But that’s not what I want.

image

I am very sad that I cannot find the solution, I have the app completely stopped just for this function, being able to share the created lists with other users.

:weary: :weary: :weary:

@jvidal
You need to change the relationship for the list.
Adalo Tutorial: Most Common Mistakes - Database Collections, Relationships, and the Infinite Menu

1 Like

Hello James_App_Maker

I have checked the relationships and they are correct, a user can have multiple lists and a list can have multiple users. I can’t find the fault. I am starting even though it is a limitation of Adalo and what I need cannot be done through an input and if through a selection field as an attachment in the captures.

This topic was automatically closed 10 days after the last reply. New replies are no longer allowed.