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.
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
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.
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.
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.
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.