Skip to main content
C
carlosp5114
September 1, 2023
Question

Update/Change existing value of a record

  • September 1, 2023
  • 1 reply
  • 0 views

Hi! I´m trying to update a value in my process model by using an script task (change value to "true" and saves it into the field "facturada) and then using the writeRecords smart service

My configuration is:

1. Script Task:

The value "true" is saved into the field "facturada" of my record. It´s important to say that I´m updating an ARRAY

2. Write Records Smart Service

In the beginning, I was updating the entire record, but this was causing that my data got duplicated (f.example if I created 2 rows, there were 4 rows). So I´m trying to update just the field I want ("facturada")

(The target in my last picture is the field I want to update (recordLineas.....recepcionada))

The error that appears is the following:

How can I fix this? Thanks a lot

    1 reply

    stefanhelzle0001
    stefanhelzle0001
    Brainy
    September 1, 2023

    You first need to modify the data in Appian before writing it to the DB. In cases where I need to do a more complex modification of data, I create an Expression which takes that data as an input. Then I can test that separately. As I suggested in the other conversation, use foreach and a!update to modify fields in a list of records.

    Terms & ConditionsAccessibility statement