How to save one to many records

Question

We have 3 records in our application say record A, record B and record C. Record A is having one to many relation with record B where record B is having one to many relation with record C. Record A is having generic details, record B is having section details which can be multiple and record C is having one editable grid having multiple entries which is present in the above section. We are facing issue while displaying and saving the value into the rule input since we are not able to use [fv!index] for record variables. We are using only one rule input of record type A. How to make sure to show the values properly and save them properly??

This is just a mock UI i created for explaining the issue. Add member will add one more row in developer details grid. Add Team will repeat the whole section again.

Stefan Helzle · Answer

I hope this quick example helps

Stefan Helzle · Answer

I spent the time to make your code work for me. The main issue is, that your did not create lists for the relationships in which you want to append items to. 
 a!localVariables(
 local!companyDetails: a!map(
 wtaManagerDetails: { /* This must be a list ! */
 a!map(
 managerName: "",
 wtaDeveloperDetails: { /* This must be a list ! */
 a!map(
 developerName: ""
 )
 }
 )
 }
 ),
 {
 a!sectionLayout(
 label: "Team Details",
 contents: {
 a!forEach(
 items: local!companyDetails["wtaManagerDetails"],
 expression: a!localVariables(
 local!managerItem: fv!item,
 {
 a!columnsLayout(
 columns: {
 a!columnLayout(
 contents: {
 a!textField(
 label: "Manager Name",
 labelPosition: "ABOVE",
 value: fv!item["managerName"],
 saveInto: fv!item["managerName"],
 )
 }
 ),
 a!columnLayout(
 contents: {
 a!textField(
 label: "Manager Number",
 labelPosition: "ABOVE",
 value: fv!item["managerNumber"],
 saveInto: fv!item["managerNumber"],
 )
 }
 )
 }
 ),
 a!gridLayout(
 label: "Developer Details",
 labelPosition: "ABOVE",
 headerCells: {
 a!gridLayoutHeaderCell(label: "Name"),
 a!gridLayoutHeaderCell(label: "Mobile No")
 },
 columnConfigs: {},
 rows: {
 a!forEach(
 items: local!managerItem["wtaDeveloperDetails"],
 expression: a!gridRowLayout(
 contents: {
 a!textField(
 value: fv!item["developerName"],
 saveInto: fv!item["developerName"],
 ),
 a!textField(
 value: fv!item["developerDesignation"],
 saveInto: fv!item[""]
 ),
 }
 )
 )
 },
 selectionSaveInto: {},
 validations: {},
 shadeAlternateRows: true,
 addRowLink: a!dynamicLink(
 label: "Add Member",
 saveInto: {
 a!save(
 local!managerItem["wtaDeveloperDetails"],
 append(
 local!managerItem["wtaDeveloperDetails"],
 a!map()
 )
 ),
 }
 )
 )
 }
 )
 ),
 a!linkField(
 links: {
 a!dynamicLink(
 label: "+ Add Team",
 saveInto: a!save(
 local!companyDetails["wtaManagerDetails"],
 append(
 local!companyDetails["wtaManagerDetails"],
 a!map()
 )
 )
 )
 }
 )
 }
 )
 }
)