- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Jul 24, 2024 08:56 AM
I 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?
Solved! Go to Solution.
Accepted Solutions
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Jul 24, 2024 06:27 PM
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?
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Jul 25, 2024 09:37 AM
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.
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Jul 24, 2024 06:27 PM
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?
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Jul 25, 2024 09:37 AM
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.
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Jul 25, 2024 07:16 PM
Oooh yeah, that's a nice set up!
