I am trying to update multiple records in a table with the same value before I create a new record. Essentially, I want to add a new product but instead of updating the same record I would like to set an enabled flag for the current product to be false then add a new one. This way I have an audit trail of past products.
Is there a way to set the attribute values without having a form to set the values? I have a selector which picks the products to update, a modify unit, then a create unit for the new product. The value being set by the modify will alway be the same but I cannot see how I can set the attribute value in the modify unit.
Hopefully that makes sense and someone is able to help.