Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
hi,
i have a group (cycle) wnd i gave lable to the fields in the group.
i created a text box with the expression-
GetCurrentField(Emp_Cyc)&' (Working Hours)'
the function GetCurrentField gives me the name of the field (Not the label i gave him)
how can i change the expression to see the label of the field in the group and not the real name??
tnx,
adi
Hi,
You can try like this
=Pick(Match(GetCurrentField(GroupName), 'Dimension1', 'Dimension2', 'Dimension3'), 'Dim1 Caption', 'Dim 2 Caption', 'Dim 3 Caption') &' (Working Hours)'
Hope this helps you.
Regards,
Jagan.
I think this is not possible
No not possible in my opinion. Maybe other experts can suggest.
Instead of giving label ,rename the field in back end with the name you want to display.
i dont want to change the name of the field.
somepne have a solution or should i give up?
Hi,
You can try like this
=Pick(Match(GetCurrentField(GroupName), 'Dimension1', 'Dimension2', 'Dimension3'), 'Dim1 Caption', 'Dim 2 Caption', 'Dim 3 Caption') &' (Working Hours)'
Hope this helps you.
Regards,
Jagan.
Hi,
If you don't want to do it in layout, you can try to create an isolate table containig the inicial and final label. I mean:
name1 name2
Dim1 Dim1 Caption
Dim2 Dim2 Caption
Dim3 Dim3 Caption
And then in the objects:
=only(p({<name1={"$(=GetCurrentField(GroupName))"}>} name2))
Hope it helps.
Marc.
Jagan Mohan's trick works