When I update a record in NocoDB I want to update only a specific field. in the same record I have few fields with checkboxes.
Scenario 1: I dont want to update or touch those checkboxes. I want only to update a different field. however, those check boxes are updated in any case. if I leave them untouched (off) , then if in my database this is marked as “Checked” it will update it and uncheck it. so basically by updating the nocodb record it is forcing the update of the checkmark fields even if I leave them untouched.
Scenario 2: I have Boolean 1, Booelan 2, Boolean 3. (Boolean = Checkbox) Lets say bool 1 is true. I want for example to make Bool 2 true but not do any other changes. if I just update the record by marking Bool 2 true, then in fact it will update the record with only Bool 2 true and will uncheck (make the other fields false / unchecked).
Overall, it makes this checkmark feature /update not very usable. hope it made sense.
while writing this I figured out that i probably just use a text field with using “0” as false and “1” as true. this would be my solution for now but would be great to get the checkmark option left not updated.