*Short version*: How can I update only select fields in a record (as opposed to specifying all the fields, which I am currently required to do).
*Longer version*: I am in process of creating a special-purpose front-end for spreadsheets. Through this front-end, I am displaying records to the user, and he can modify some of the fields and update the record. When I am updating a record, I have to specify all the record's fields, otherwise, missing fields are wiped out - This seems to be the behavior of the API. This is a problem since some of the fields are formulas, and the user is interested in seeing the values in my interface so I'm not fetching the formulas, so when I'm saving the record, I am saving the value instead of the formula (no changes were made to this field) and this wipes out the formula. Any way I can update only a subset of the fields in a record?
