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?
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?
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.
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.
Oooh yeah, that's a nice set up!