Linking Two Things between App data Tables

kpeksenar · 2024-09-10T21:00:30.217Z

Hi Bubble Community,

I have two datasets, one named Products and one named Vendors. In Products, I have a field called Vendor which is a List of Vendors. In Vendors, I have a field called Products which is a List of Products. A vendor has many products and each product can have many vendors.

I have created a page for vendors to add products. Once the vendor inputs metadata into the input text box, they click a button to submit their new product triggering a workflow:

image967×443 54.4 KB

The current set up I have creates a new product, and a new vendor in their respective tables but doesn’t add the listed product to the Vendors table, nor the vendor name to the Product table.

Is there a way to add these two fields to their counterpart tables (ie: add the product to the Vendor table’s product field, and vice versa)? I would like to add the product to an existing vendor if the vendor already exists, or create a new vendor when the vendor does not exist. This was the closest existing thread to troubleshoot I found.

aryan2003dikshit · 2024-09-10T21:42:35.549Z

In step 3 do : make changes to product - add result of step 2 create a new vendor
step 4 : make changes to vendor - add result of step 1 create a new product.

And under both product and vendor data types you need to have them added to their counterpart tables.

kpeksenar · 2024-09-11T02:04:42.652Z

Hi @aryan2003dikshit I added in steps 3 and 4 to create a new vendor and new product. However, when I added in the new sample product, the vendor still does not show. I would like to join the “This is a sample Vendor” to the Vendor field in the same row as the “This is a sample Product” and vice versa.

image1290×75 7.47 KB

image1252×95 5.96 KB

Could you expand on adding product and vendor to their counterpart tables?

kpeksenar · 2024-09-11T02:09:16.094Z

For context, here is my Vendor dataset:

image767×342 13.3 KB

And here is my Product dataset:

image712×398 15.8 KB

aryan2003dikshit · 2024-09-11T02:21:21.956Z

could you show me both the workflows as well?

kpeksenar · 2024-09-11T20:11:36.309Z

@aryan2003dikshit
Here is the workflow. Step 1:

image1316×567 25.8 KB

Step 2:

image1317×310 17.8 KB

Step 3: Make changes to Product was no problem.

image1317×277 16.7 KB

Step 4: Make changes to Product since result of step 1 was to create a new product. There was not an option of Make changes to Vendor.

image1300×272 16.7 KB

Step 5 just resets the page for the vendors to add in their product metadata.

J805 · 2024-09-11T20:49:47.306Z

Just as an alternative. Have you thought about adding a linking table instead. Each product-link would have a single product and a single vendor attached to it. This allows you to scale to an unlimited amount of product and vendor attachments. You won’t be limited to trying to have a list on data type. Does that make sense? Would something similar to that work for your situation? Is there any reason you can’t do it that way instead?

Let me know your thoughts.

kpeksenar · 2024-09-11T22:58:43.529Z

@J805 That could work since the vendor-product relationship would be many-to-many. My main concern is linking these tables. How would I connect the individual product and vendor tables to the bridge table? In SQL, there would be two separate keys to join the individual tables to the linking table.

I’ve built the workflow so that if a customer clicks on a vendor, all the products that vendor offers is displayed. As long as I can link the individual product and vendor tables to the linking table, then this would likely work.

J805 · 2024-09-11T23:30:53.303Z

Yeah. If you save the vendor and the product on the data record then it would work just like how you said.

kpeksenar · 2024-09-11T23:33:34.540Z

@J805
Thanks for the idea. How would I actually link the vendor from the vendor table to the vendor in the bridge table, and the product from the product table to the product in the bridge table? Is Bubble smart enough to link them by knowing their names are the same?

tylerboodman · 2024-09-12T00:09:36.664Z

Like this using another datatype vendor-products | Bubble Editor

kpeksenar · 2024-09-12T23:15:24.347Z

Great, thanks everyone for your help!

J805 · 2024-09-13T04:41:46.335Z

Glad that helped.

lowcodehelpers · 2024-09-13T10:11:30.263Z

Hey @kpeksenar this is Nathan from lowcodehelpers. I sent you a DM.

system · 2024-11-19T21:00:38.113Z

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