Updating Database Records

Automate database record updates with the Database Book.

To update a singular database record, first retrieve the record you want to update, then use set to modify its field values.

Syntax

set <object>'s <field> to "<value>"

Examples

Example 1: Updating a person's name

get a person from database whose ID is 3
set the person's name to "Jane Doe"

Example 2: Updating an employee's designation

get an employee from database whose employee_id is 918756423
set the employee's designation to "LEAD"

Example 3: Updating an incident record

get a incident from database whose ID is 12345
set the incident's FirstName to "Abby"