请教大家:
calculation expression pane当中,可否对lookup [hierarchy]类型字段进行处理?
具体场景:
Main Table: Team
Field 1: First Name (text)
Field 2: Family Name (Lookup [Hierarchy])
Field 3: Full Name (text, calculation field)
Lookup [Hierarchy]: Family Names
Field 4: Family Name (text)
目标为Field 3 = Field 1, Field 2
我试了concatenate语句,但是似乎对hierarchy lookup table中的字段不起作用,结果出来的是一串数字+first name。那位能够指点一下?
十分感谢!