# How to share DB **URL:** \ **Category:** Get Help\ **Created:** [December 30, 2020, 12:05pm UTC](https://forum.adalo.com/t/how-to-share-db/7447 "2020-12-30T12:05:07Z")\ **Posts on this page:** 15\ **Page:** 1
**Author:** ![jvidal](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.adalo.com/jvidal/32/5010_2.png) [@jvidal](https://forum.adalo.com/u/jvidal)\ **Post date:** [December 30, 2020, 12:05pm UTC](https://forum.adalo.com/t/how-to-share-db/7447/1 "2020-12-30T12:05:07Z")
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. ![Blank diagram](https://us1.discourse-cdn.com/flex020/uploads/adalo/original/2X/7/7b494f8d49fc62f51a124c07b86b6f6e736b149c.png) ---
**Author:** ![DylanS](https://avatars.discourse-cdn.com/v4/letter/d/90ced4/32.png) [@DylanS](https://forum.adalo.com/u/DylanS)\ **Post date:** [December 30, 2020, 12:42pm UTC](https://forum.adalo.com/t/how-to-share-db/7447/2 "2020-12-30T12:42:19Z")
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. ---
**Author:** ![jvidal](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.adalo.com/jvidal/32/5010_2.png) [@jvidal](https://forum.adalo.com/u/jvidal)\ **Post date:** [December 30, 2020, 6:31pm UTC](https://forum.adalo.com/t/how-to-share-db/7447/3 "2020-12-30T18:31:12Z")
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. ![Consult](https://us1.discourse-cdn.com/flex020/uploads/adalo/original/2X/0/0579fb7c8a148224ab3982e10ac52b81c266eca1.png) ---
**Author:** ![jvidal](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.adalo.com/jvidal/32/5010_2.png) [@jvidal](https://forum.adalo.com/u/jvidal)\ **Post date:** [January 1, 2021, 8:48pm UTC](https://forum.adalo.com/t/how-to-share-db/7447/4 "2021-01-01T20:48:17Z")
any idea to carry it out? ---
**Author:** ![jvidal](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.adalo.com/jvidal/32/5010_2.png) [@jvidal](https://forum.adalo.com/u/jvidal)\ **Post date:** [January 7, 2021, 3:04pm UTC](https://forum.adalo.com/t/how-to-share-db/7447/5 "2021-01-07T15:04:01Z")
I need help please, I can’t solve it. Thank you. ---
**Author:** ![jvidal](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.adalo.com/jvidal/32/5010_2.png) [@jvidal](https://forum.adalo.com/u/jvidal)\ **Post date:** [January 14, 2021, 9:34am UTC](https://forum.adalo.com/t/how-to-share-db/7447/6 "2021-01-14T09:34:47Z")
Some Adalo expert can help me please. Thank you! ---
**Author:** ![crmorris2](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.adalo.com/crmorris2/32/5681_2.png) [@crmorris2](https://forum.adalo.com/u/crmorris2)\ **Post date:** [January 14, 2021, 11:15am UTC](https://forum.adalo.com/t/how-to-share-db/7447/7 "2021-01-14T11:15:54Z")
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 ---
**Author:** ![jvidal](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.adalo.com/jvidal/32/5010_2.png) [@jvidal](https://forum.adalo.com/u/jvidal)\ **Post date:** [January 16, 2021, 8:44pm UTC](https://forum.adalo.com/t/how-to-share-db/7447/9 "2021-01-16T20:44:10Z")
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. ![ShopyListQuery](https://us1.discourse-cdn.com/flex020/uploads/adalo/original/2X/0/01fbbd2e9ec950798e3b412f8d9892da12704229.png) ---
**Author:** ![crmorris2](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.adalo.com/crmorris2/32/5681_2.png) [@crmorris2](https://forum.adalo.com/u/crmorris2)\ **Post date:** [January 16, 2021, 9:28pm UTC](https://forum.adalo.com/t/how-to-share-db/7447/10 "2021-01-16T21:28:21Z")
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 ---
**Author:** ![jvidal](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.adalo.com/jvidal/32/5010_2.png) [@jvidal](https://forum.adalo.com/u/jvidal)\ **Post date:** [January 17, 2021, 11:07pm UTC](https://forum.adalo.com/t/how-to-share-db/7447/11 "2021-01-17T23:07:24Z")
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](https://us1.discourse-cdn.com/flex020/uploads/adalo/original/2X/f/f3c17f0690acc806243e95caf7d8aa2d6d58fcc9.png) ![image](https://us1.discourse-cdn.com/flex020/uploads/adalo/original/2X/1/1ff576a74645fd90095734e3c46c2e8b50f4afeb.png) ---
**Author:** ![jvidal](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.adalo.com/jvidal/32/5010_2.png) [@jvidal](https://forum.adalo.com/u/jvidal)\ **Post date:** [January 18, 2021, 6:54pm UTC](https://forum.adalo.com/t/how-to-share-db/7447/12 "2021-01-18T18:54:01Z")
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](https://us1.discourse-cdn.com/flex020/uploads/adalo/original/2X/7/77af3471b468d1911636f6733a0f6ebd1d44bfa6.png) ![image](https://us1.discourse-cdn.com/flex020/uploads/adalo/original/2X/1/15ca39904ec6ec52fcb51da55b67ab5d29c8b9f2.png) ---
**Author:** ![jvidal](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.adalo.com/jvidal/32/5010_2.png) [@jvidal](https://forum.adalo.com/u/jvidal)\ **Post date:** [January 18, 2021, 6:55pm UTC](https://forum.adalo.com/t/how-to-share-db/7447/13 "2021-01-18T18:55:42Z")
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. 😩 😩 😩 ---
**Author:** ![James\_App\_Maker](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.adalo.com/james_app_maker/32/37288_2.png) [@James\_App\_Maker](https://forum.adalo.com/u/James_App_Maker)\ **Post date:** [January 18, 2021, 6:57pm UTC](https://forum.adalo.com/t/how-to-share-db/7447/14 "2021-01-18T18:57:50Z")
@jvidal You need to change the relationship for the list. [Adalo Tutorial: Most Common Mistakes - Database Collections, Relationships, and the Infinite Menu](https://forum.adalo.com/t/adalo-tutorial-most-common-mistakes-database-collections-relationships-and-the-infinite-menu/7686) ---
**Author:** ![jvidal](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.adalo.com/jvidal/32/5010_2.png) [@jvidal](https://forum.adalo.com/u/jvidal)\ **Post date:** [January 19, 2021, 2:53pm UTC](https://forum.adalo.com/t/how-to-share-db/7447/15 "2021-01-19T14:53:11Z")
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. ---
**Author:** ![system](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.adalo.com/system/32/40401_2.png) [@system](https://forum.adalo.com/u/system)\ **Post date:** [January 29, 2021, 2:53pm UTC](https://forum.adalo.com/t/how-to-share-db/7447/16 "2021-01-29T14:53:14Z")
This topic was automatically closed 10 days after the last reply. New replies are no longer allowed.