Skip to main content
October 24, 2023
Question

How to write to multiple records in one Process

  • October 24, 2023
  • 4 replies
  • 0 views

An Award Record has 3 sections: Section 1, Section 2, and Section 3. Section 1 and 2 combine to serve as a unique identifier. When you edit Section 3 of an Award Record, all of the Awards with the same values for Section 1 and 2 should be updated as well. This process model updates the value for Section 3, but it does not check to see if there are other awards with the same combination of Section 1&2 before writing to the DB.

I was told to "build a dictionary in building the CDT before the DB write and write the array".

Any help would be greatly appreciated!

Thank you

4 replies

mikes0011
Brainy
October 24, 2023

This doesn't make much sense here with such a vague description of the data structure.  My advice in general is to map it out on a whiteboard and try to simplify what updates will be needed to the structure given your on-form update of any particular data element, and go from there.

dwightbAuthor
October 24, 2023

Is there any information I can add to make it more understandable? I have the whiteboard mapped out; I understand what I want to do just now how to get Appian to do it. If you edit "Award.A.B.1" to "Award.A.B.2", then it would need to edit all awards in the database that start with "Award.A.B." and change the last value to "2".

mikes0011
Brainy
October 24, 2023

I don't really understand though - are the values being stored/edited, actually hardcoded into different tables as duplicate copies or something?  In a relational DB there would typically be no need to manually change values in related tables if things are properly normalized.