HELP - DATA BASE structure

Need help Database
1

Hello everyone, I hope you’re all well.

I am facing issues regarding the organization of my Database. I am currently developing a project management app for a consulting company.

To summarize, I currently have the following app data :

image
image1374×1166 108 KB

image
image988×1161 49.7 KB

image
image1376×833 78.1 KB

The managers and Freelancers have access to the platform with different user roles. The permanents contract workers and Business Bringers do not.

I am currently working on the personal space for each freelancer and I do not know how to setup my database in order for the freelancers to be able to see the missions that are assigned to them. I made a link between the tables “Deals Freelance” and “Freelancers” but the result I have is the one below.

image
image1306×139 10.9 KB

Please tell me if you need further details regarding the problem I am facing.

Thank you a lot in advance for your help!

2

Have the datatype of Missions have a field of Freelancer

When you want to show the freelancer their missions, do a search for mission constrain by Freelancer is current user

3

Hello Boston,

Thank you for your answer!

I do have a Field of Freelancer in my datatype mission, see below:

image
image3585×652 129 KB

But should I switch it with the User then, instead of Freelancer?

Because I will have the same issue with my permanent contracts, and these people are not users.

Do you know why I can only see some sort of ID instead of the full name?

Thanks a lot for your help!

Have a nice day,

4

When you are in the App Data section of the Data tab in the editor, there is a button in upper left called ‘Primary Fields’, click that button and you can change the field that is used in the editor database. Likely right now the Freelancer data type is set to unique ID.

I personally would be finding a way to distinguish using the same data type between a Freelancer and a Permanent Contract so as to make things simpler. One of the things that I’ve come to understand in Bubble database is everything comes back to the User data type.

  1. Only the User data type is created when you start a new app
  2. Every single data type you add will have a built in field of Creator which is the User data type
  3. Very easy to use the dynamic expression ‘current user’

With that in mind, I’d suggest making the Permanent Contracts a User, even if they will never actually sign in to their user account. You can make a dummy email address that you append a value to for each like 1-permanentcontract@email.com

But, in all honesty, there are many different ways to achieve the same type of end result, and other developers may have ideas that work for them that differ from mine.

5

Thanks a lot for your help Boston, I can now see the names instead of the unique IDs!

That is well noted for the User datatype thank you, I’ll give it a try :slight_smile:

Have a nice day,