set local!value to multiple row

Question

local!a;type!table(), 
 local!b:{a,b,c} 
 local!c:{1,2,3} 
 a!save(target:local!a.column1,values:local!b). 
 a!save(target:local!a.column2,value:local!c). 
 why my return on local!a only has{column1:a,column2:1} 
 where the other two rows go?

Peter Lewis · Answer

In general this won't work because you're mixing types. The original type is a single CDT and you're trying to save a list of text / integer into one of those fields. But not only that - even if your original type was a list of CDT, this still won't work - you will end up seeing the first value only. In general I suggest doing a different method: using a!forEach() to exactly format the results that you want. Something like this would work: 
 a!localVariables(
 local!a,
 local!b:{"a","b","c"},
 {
 a!buttonArrayLayout(
 buttons: a!buttonWidget(
 label: "Blah",
 saveInto: a!save(
 target:local!a,
 values: a!forEach(
 items: local!b,
 expression: a!update(
 'type!Case'(),
 "assignee",
 fv!item
 )
 )
 )
 )
 )
 }
)

set local!value to multiple row

Top Replies