0 Replies Latest reply: Apr 18, 2017 6:08 AM by Laxmaiah Chowdary RSS

    Concatenate TableName with associated FieldName using GetFieldSelections

    Laxmaiah Chowdary

      Hi Folks,

      I use Text Object and I am trying to concatenate Tablename with Fieldname using GetFieldSelections().

       

      For example, TableA has a1,a2,a3,a4 fields. TableB has b1,b2,b3 fields. TableC has c1,c2,c3 fields.

       

      When I select fields a1,b2,c3 which are in different list boxes, it shows TableA,TableB,TableC/a1,b2,c3 in Text Object if I use =GetFieldSelections(%TableName)&'/'&GetFieldSelections($Field) or concat(GetFieldSelections(%TableName)&'/'&GetFieldSelections($Field)) or concat() or =concat(GetFieldSelections(%TableName))&'/'&concat((GetFieldSelections(%FieldName)))


      But I need to see TableA/a1,TableB/b2,TableC/c3.


      Could you please help me with this.


      Note:I can use concat($TableName&'/'&$Field) to get result but the performance is dead slow on user selections.



      Thanks