So
I have tried and failed. I am not sure I understand some of the basics of Bubble and unfortunately the lessons and manual cover the bare bones so I have gathered no enlightenment from there.
I have 3 bits of data I want to reference:
-
User
-
Project
-
Role on the project
I have set up the users, and project names, and then tried a separate data type for role, tried incorporating it in to the project data type itself but for the life of me I cannot make it do what I am trying to do which is:
-
User filters on the first dropdown (project)
-
User filters on the second dropdown (all users)
-
I then want to assign a role (such as Project Manager) to that user selected above, and have it write back to the project data and the user data to ensure the person selected is the Project Manager for that project. But they could have other roles on the project, and conversely have other projects they are the Project Manager for.
What am I doing wrong?
Paul