I have a form that is used to bulk edit a set of records. The form shows fields where the user can enter data, and if they do, those new values are applied to the selected records. When editing a single record, there is a checkbox that enables other input fields. The state of that checkbox is also saved as part of the record's data.
My question is how should I handle that checkbox and those conditional fields when bulk editing?
In the example below, if the Cake and Ice Cream inputs are disabled, the user cannot change all Ice Cream orders to Chocolate unless they check the box to enable the field. But checking the box gives Dessert to all selected records, which is not the intention.
If the fields are not disabled, records without Dessert will end up with a value stored for Cake and Ice Cream that they shouldn't have. We can probably manipulate the database to check if a record doesn't have the right option and skip adding the Cake and Ice Cream, but then the interface is misleading when it says you are editing more records than will actually be affected.
(Removing the checkbox is not an option because it has meaning within the real data. We want to know if the person ordered dessert even if they haven't selected Cake and Ice Cream yet.)