How Can I change "45 - Cars (Group)" in a text.Thanksswith( local!user: a!forEach( items: getgroupsformemberuser(loggedInUser()), expression: if(upper(group(fv!item,"groupName")) = "cars", fv!item, {} ) ), if(length(local!user)=1,local!user[1],local!user[1]))
Discussion posts and replies are publicly visible
Can you be more specific than "in a text"? Do you want the whole group description string to become text, or do you want just the name to display, or what? Have you tried wrapping fv!item in toString() to see what will happen?
If I understood correctly you just want the group to be returned as text. If yes, then you can use concat() to return the desired text output.
a!forEach( items: getgroupsformemberuser(loggedInUser()), expression: if(upper(group(fv!item,"groupName")) = "cars", concat(tointeger(fv!item)," - ",group(fv!item,"groupName")), {} )
Hope it helps.
thank you Harsha. that's what I wanted, to pass "45 - Cars (Group)" to text, "45 - Cars"