Update record
Changes fields of one record and returns the old values.
MCP tool quickbase_write → update_record
write
Opens the record in edit mode, sets the fields you pass and saves; fields you leave out stay as they are. The answer lists each changed field with its previous and new value, so a wrong change is undone by calling update_record with the previous values. If someone saved the same record while it was open, the call fails and changes nothing. It does not wait for your OK because it is undone in one call, but a Pipelines or notification rule in your app can still run on save, for example when you change who a record is assigned to.
Parameters
| Name | Type | Description |
|---|---|---|
| app string required | string | App name as it appears under My apps, e.g. 'Field Ops'. |
| table string required | string | Table name as it appears in the app's sidebar, e.g. 'Work orders'. |
| record_id integer required | integer | Record ID# from run_report, search_records or create_record. |
| fields object required | object | Field label to new value, e.g. {'Priority': 'High'}. Only these fields change. |
tools/call
{
"jsonrpc": "2.0",
"id": 1,
"method": "tools/call",
"params": {
"name": "quickbase_write",
"arguments": {
"operation": "update_record",
"arguments": {
"app": "Field Ops",
"table": "Work orders",
"record_id": 1042,
"fields": {
"Assigned to": "Dana Whitfield",
"Priority": "High"
}
}
}
}
}Example response
{
"content": [
{
"type": "text",
"text": "{ ... same JSON as structuredContent ... }"
}
],
"structuredContent": {
"record_id": 1042,
"table": "Work orders",
"updated": {
"Assigned to": {
"previous": "Sam Ortiz",
"current": "Dana Whitfield"
},
"Priority": {
"previous": "Normal",
"current": "High"
}
}
},
"isError": false
}