Skip to Content
0
Former Member
Nov 17, 2008 at 06:10 AM

[求助]calculation 对于lookup field的使用

79 Views

请教大家:

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。那位能够指点一下?

十分感谢!