Table Repeater using a Lookup with Inputs to modify the line details
Scenario: Order form, with repeated order lines, the user clicks a Product from a dropdown to add the line of product details, which can consist of 10 columns of information, like "SKU", "Description" "Colour" "Material" "Price" etc. The user wants to be able to edit any of those bits of information in the Order (but just as a once-off), and not affect the original Product Lookup table.
Will this work?...
0. add a Products Repeater to serve as the Order's lines to be charged for
1. Product repeater lines have a Product Select box (search for products) to work as an "SKU Lookup"
1.b. and a TextInput for each column wanting to be presented in the order such as "SKU", "Description" "Colour" "Material" "Price" etc.
2. add "->afterStateUpdated" to the Product Select
2.b. when changing the Product Select, all fields for that repeater line will be updated using $set(field, {product.field.value})
3. When saving, the data is saved to the one JSON column (as recommended in the docs for repeaters)
PS: I probably could have just dumped all that into Junie + Claude Sonet and it would have done it for me 😄
0 Replies