Update Record

The Update Record Node is used to update one or more fields in an existing record in a Data Table using the values stored in Custom Service Variables. An existing record is updated first by specifying the Lookup Value for the predefined Data Table Key Field, then defining the fields and values to update in the record.

If you are new to Data Tables, please see Managing Data Tables for a better understanding of Data Table records and the importance of the Data Table Key Field.

Branch Name	Mandatory	Description
Success	Yes	Taken when a record was successfully found that matched the Lookup Value and the configured fields have been updated using the values in the specified Custom Service Variables.
Record Not Found	Yes	Taken when the Data Table did not contain a record that matched the configured Lookup Value.
Field Not Found	Yes	Taken when a record was found but a field configured as a "Must Find Field" was not found in the selected record.
Failed	Yes	Taken if the Data Table 'Read Only' property is true or the unlikely event that an unexpected platform issue occurred while attempting to access the Data Table.

Node Properties

The Node Properties is where you to define the fields and values to use when updating an existing record. Custom Service Variables are used to assign values to the Data Table fields. When a Data Table has been selected the name of the Key Field for that Data Table is shown. A record will be updated where the Data Table Key Field contains a value that matches the value specified in the Lookup Value. The example below will find a record in the Data Table where the Key Field 'ServiceNumber' is equal to the Lookup Value '01132265408' and assign the value of the Custom Service Variable '@RingDuration' to the field named 'RingDuration'

The first step is to choose the Data Table using the magnifying glass icon. Once this has been done the name of the Key Field for that Data Table is displayed.

The second step is to enter the value you want to use in the Lookup Value field or select a variable that contains the information.

The next step is to specify the fields you wish to update and the variables that contain the new values for them. to do this press the [Add New] button to add to the field selection configuration. The following dialog will be shown:-

First specify the Field Name and then the Source Variable that will contain the new contents for that field. Repeat this step for all the fields you wish to be updated in the record.

The Field Name drop down list will only contain values when the Data Table contains some records. This list is initially populated with the fields found in the first 10 records in the Data Table. Pressing the [Refresh Fields] button will force a full scan of all the Data Table records.

Field Names are not restricted to the values in the drop down list and can be entered manually.

Must find Field

Data Table records are flexible and do not need to have the same fields defined for each record. The Must Find Field setting allows you to control the call flow where a record has successfully been found in the Data Table but the record did not contain the required field.

The Field Not Found branch will be taken when the Must Find Field is set to 'Yes' and the specified field name was not found in the selected record.

Viewing Logs

Once the node has been used in a call plan pressing the View Log button on the Node Settings screen will show the latest audit logs that have been generated by the node for inbound calls.