+5I have 3 tables - Gift Hamper, Products, BOM
Gift hamper - has list of gift hamper ids/names
Products - have list of products
In BOM we assign products & quantity to Gift Hamper (one gift hamper can have multiple products)
While linking a product in BOM, I would like to see some values from Product columns (eg stock available). I would like to do this in grid format & not add each row individually using form.
How do I do so?
Best answer by TheTimeSavingCo
Hmm, perhaps try using an Interface, helper table, and automations for this? In the screenshot below, I've got a record picker to select the BOM Assembly and a list view to display the products I've currently got linked to the BOM. Below it is a Grid view that displays all the available products and I can link it to the BOM Assembly
Once I add products to a BOM Assembly, they'll show up in the List view, and I can update the "BOM Quantity" field to say how many of that product I want for this gift hamper
After I've fully assembled the hamper, I'd run an automation via a button that would grab all of this data and create it in the "BOM" table, and also clear out all the existing data, does that make sense?
+31Hmm, perhaps try using an Interface, helper table, and automations for this? In the screenshot below, I've got a record picker to select the BOM Assembly and a list view to display the products I've currently got linked to the BOM. Below it is a Grid view that displays all the available products and I can link it to the BOM Assembly
Once I add products to a BOM Assembly, they'll show up in the List view, and I can update the "BOM Quantity" field to say how many of that product I want for this gift hamper
After I've fully assembled the hamper, I'd run an automation via a button that would grab all of this data and create it in the "BOM" table, and also clear out all the existing data, does that make sense?
+5Hmm, perhaps try using an Interface, helper table, and automations for this? In the screenshot below, I've got a record picker to select the BOM Assembly and a list view to display the products I've currently got linked to the BOM. Below it is a Grid view that displays all the available products and I can link it to the BOM Assembly
Once I add products to a BOM Assembly, they'll show up in the List view, and I can update the "BOM Quantity" field to say how many of that product I want for this gift hamper
After I've fully assembled the hamper, I'd run an automation via a button that would grab all of this data and create it in the "BOM" table, and also clear out all the existing data, does that make sense?
Implemented little differently. But the idea worked! Thank you so much.
Added products to gift hamper. After selecting all products, used automation to add products to bom & remove from gift hamper > products field. Updating quantity in bom. The product card shows quantity available and allows us to select variant right away.
+31Implemented little differently. But the idea worked! Thank you so much.
Added products to gift hamper. After selecting all products, used automation to add products to bom & remove from gift hamper > products field. Updating quantity in bom. The product card shows quantity available and allows us to select variant right away.
Oooh yeah, that's a nice set up!
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.