how to edit groups in group picker which are stored in database as groupids with a related action from a form

Question

Peter Lewis · Answer

This part looks like the issue to me in your group picker: 
 saveInto:{
 union(local!groups,local!groups),
 a!foreach(local!groups,append(local!groups,{groupid:fv!item.groupid}))
}, 
 Your saveInto should receive either a variable to save into or a!save() to explicitly define a target variable and value. In your case, I think you need to save the results of this picker into a rule input so that the datase will be updated once you change the groups. 
 I'm not exactly sure how you're using the rule inpt (so it may not be this easy), but the first thing I'd try is to just define your save as local!groups. Then you could have your submit button transfer the items from local!groups back to your rule input rather than trying to do it all within this component.

Mike Schmitt · Answer

The way you have the a!save() inside an a!forEach() loop, I'm not surprised it's creating a repeating list of results inside your ri!attendees variable. I think you might have more luck structuring it like this instead: 
 a!save(
 ri!attendees,
 rule!APN_Distinct(
 a!forEach(
 local!groups,
 {
 groupId: tointeger(fv!item)
 }
 )
 )
) 
 You should set up a utility rule in your system i.e. ' APN_Distinct() ' which handles the " union(ri!array, ri!array) " functionality. This will allow you to skip using the ugly (and sometimes inefficient) manual use of the union() function in hardcode -- for instance, in my code snippet above, you would've had to run the a!forEach() loop twice to do a self-union, but instead we can just pass it straight into the utility rule and the rule handles it.

how to edit groups in group picker which are stored in database as groupids with a related action from a form

Top Replies