Data Structure Headaches


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?


You’ll want to make sure the app is public first of all, I wasn’t able to check it out.

Re: your question -
Add lists of items (Projects for example) on the User Object.
You can then assign (add) these as you need for searching / assignments purposes.

For example, if you want to have Users assigned to a project, you’d

  1. Create a list of Projects (type project) on the user object
  2. Add the project you want to that list
  3. Create a project manager’ type: user on the Project object
  4. Assign the user to that field.

That allows for a lookup/search.

It’s confusing at the start but play around with it and you’ll get the hang of it in no time.

This topic was automatically closed after 70 days. New replies are no longer allowed.