While saving editable grid one record is saving remaining records is storing null

Question

I have ProjectTeam CDT for this i have created editable grid to submit list of records 
 1.Interface configuration 
 
 2.Procees start form configuration 
 
 3.variable configuration 
 
 4.debugging form submitting two records in editable grid 
 
 5.Process history 
 
 6.after completing process only one record saving one record is null as shown in screeshot 
 
 7.ProjectTeam CDT

addRowlink: a!dynamicLink(
label: "Add Employee",
/*
* For your use case, set the value to a blank instance of your CDT using
* the type constructor, e.g. type!Employee(). Only specify the field
* if you want to give it a default value e.g. startDate: today()+1.
*/
value: {
'type!{urn:com:appian:types:DSR}DSR_ProjectTeam'()
}

,
saveInto: {
a!save( local!projectteam, append(local!projectteam, save!value)),
a!save(ri!DSR_ProjectTeam, append(local!projectteam, save!value))
}
),

any suggestions on this Please let me know any changes required 
 Thanks

Mike Schmitt · Accepted Answer

Both of these are configured slightly incorrectly. On the Inputs tab (as Stefan mentioned earlier) you need to make sure the CDTs aren't saving back into the PV, and instead, do that in the Outputs tab.

Stefan Helzle · Answer

a!localVariables(
 local!a: {
 {projectteamid:220, projectid:196, roleid:3, employeeid:1, startdate:"10/17/2020", enddate:"10/17/2020", description:"ASD"},
 {projectteamid:221, projectid: 4 , roleid:7, employeeid:2, startdate:"10/17/2020", enddate:"10/17/2020", description:"ASD"}
 },
 local!b:70,
 a!forEach(
 items: local!a,
 expression: updatedictionary(
 fv!item,
 {projectid: local!b}
 )
 )
)

Mike Schmitt · Answer

I agree with everything Stefan is saying so far; honestly, I'd go one step further for simplicity's sake (since you're only trying to write to 2 separate DSEs) and abandon the Write to Multiple DSE approach and just string together two separate single Write to DSE nodes. These are much easier to understand when it comes to writing the autogenerated values (i.e. primary key IDs) back to the process PV, and it's a lot easier to troubleshoot.

While saving editable grid one record is saving remaining records is storing null

Top Replies