Skip to main content
D
danielc9731
September 3, 2024
Question

How to save data that is split into multiple tables using records

  • September 3, 2024
  • 2 replies
  • 0 views
Hello Team, can you help me with this here, please?

I have a form (parent record), which relates to more or less 15 different tables (records). 

Most of these tables have a 1-1 relationship with the parent record and, in about 3 of them, the parent record has a 1-N relationship. 

Knowing that all these tables are filled in the same form, and everything occurs in the same process. What is the best approach in this case?

Thanks

2 replies

venkatrea696188
venkatrea696188
September 3, 2024

Are you looking for something in particular . Appian as leverage to write to child Records from parent (Automatically Mapping Primary key of Parent to Child).  What is the implementation  that you currently have??

Try Using single variable and Single write to Records without extra Mappings that we used to do in past. It will decrease the memory consumption and removes extra Nodes in process .

https://docs.appian.com/suite/help/24.2/record-type-relationships.html#write-and-delete-related-records

kumara0180
kumara0180
September 3, 2024

Step 1 Create Rule inputs for all the records in the interface

Step 2 Write the Parent Record

Step 3 Update the parent record Id in all the child records and then write them in DB

Terms & ConditionsAccessibility statement