Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Concatenate TableName with associated FieldName using GetFieldSelections

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


0 Replies