Database Structure / Zoho Integration

Need help Database
1

Hello,

I’m new to Bubble and trying to figure out the best way to structure my database for a marketplace app.

There will be 3 different types of users (REFERRAL PARTNERS, CLIENTS and VENDORS) that log in to create/view DEALS and QUOTES. REFERRAL PARTNERS will be able to create their own login, a CLIENT login and a DEAL. CLIENTS can log in to create DEALS on their own as well. VENDORS can log in to view DEALS and respond with a QUOTE. What is the best way to structure a database so all these users/things interact correctly?

Here are some screenshots of my first attempt:

35%20AM
35%20AM2678×1056 168 KB
51%20AM
51%20AM2698×1028 166 KB
12%20AM
12%20AM2696×1048 169 KB
00%20AM
00%20AM2672×978 128 KB
09%20AM
09%20AM2678×938 150 KB

The built-in field Creator - User is confusing to me. Can someone please explain?

My Zoho CRM is set up with these 5 modules interacting correctly. Would it be better to create an API with the CRM?

Thank you,

Max

2

Anyone have any ideas of how this could be best structured?

3

Hey mate, you can do away with the zoho crm integration. What you are looking to do can be structured in Bubble easily enough.

I’d suggest creating a new Data Type called something like ‘User Category’, then enter your 3 different types of users. Then all of your users are set-up under the default User Data Type (table). Just add User Category as a Field in the User Data table and ensure it’s type is set to ‘User Category’.

Then just build everything using the User Data table and filter your searches / views based on the User Category field.

This should be a good start anyway. Good luck!

1 Like