This node updates specific fields of an existing database record.
The Set Record Properties node modifies data in the cloud.
The Set Record Properties node allows you to update one or more columns of a specific record. It dynamically exposes inputs for the table's columns. You can choose to update only the connected fields or overwrite the entire record.
General
| Data | Description |
|---|
| Class | The database collection. |
| Record Id | The ID of the record to update. |
| Properties to store | "Only specified" (updates only connected inputs) or "All" (saves the entire model state). Default: "Only specified". |
| Store to | "Cloud and local" (saves to DB) or "Local only" (updates temporary cache only). Default: "Cloud and local". |
Properties
| Data | Description |
|---|
| * | Dynamic inputs for table columns. Connect values here to update them. |
Actions
| Signal | Description |
|---|
| Do | Triggers the update (save) operation. |
Outputs
Events
| Signal | Description |
|---|
| Success | Triggered when the update is confirmed by the server. |
| Failure | Triggered if the update fails. |
Usage
Updating a Profile
- Select Class: "Profiles".
- Connect the current user's Profile ID to Record Id.
- Connect a Text Input to the "Bio" input port.
- Trigger Do when the user clicks "Save".
Detailed Behavior
- Partial Update: By default ("Only specified"), it sends a PATCH request with only the changed fields, which is efficient and safe.
- Optimistic UI: The local model is updated immediately. If the server request fails, you may need to handle rollback manually (though the node will trigger Failure).
Troubleshooting
- Missing Id: The update will fail if Record Id is empty.
- Permission Denied: Ensure the user has write access to this record via RLS policies.