Concatenate text field in repeating subform?

Follow

Gwen Wilson

• May 29, 2020 15:02

Can you concatenate a the contents of a text field in a repeating subform? Basically I'm capturing user names and want to concatenate them into one field in the parent form. So, this would be similar to a sum of the array values in a formula field, but with text.

Reason, I want to be able to query against this field to return all items assigned to one person. So, I can do a keyword search against the concatenated field to find the ones I want.

Thoughts? Thanks!

 

0

• 

  Gwen Wilson

  • May 29, 2020 15:45

  I did get something that will serve my purpose, but it's "ugly". If you have any better solution, I'd love to hear. 

  "${subform_PreventativeActions/txt_ActionOwner1:[*]}"+"${subform_PreventativeActions/txt_ActionOwner1:[this]}"

  So, the last action owner selected shows up duplicated. But all the other owners are fine.

  0

  Comment actions Permalink
• 

  AgilePoint NX Support

  • June 21, 2020 06:21

  Gwen,

   

  You can use the eFormHelper method which keep the code clean and less lines.

  https://documentation.agilepoint.com/00/appbuilder/cloudjsGetSubFormData.html

   

  Thanks

  AgilePoint NX Support

  0

  Comment actions Permalink

Please sign in to leave a comment.