1 of 1 people found this helpful
If you only need to display a field from the Employee object, there are several ways to achieve this.
I prefer using the EvalField() function in this case:
$(EvalField("Employee#", Owner_Valid, "DisplayName"))
Thanks for this solution. Can you learn this somehow or is this just a result of a lot of experience?
However, great tip, great product!
Normally is this case you would use the relationship between the two business objects, but there isn't a formal relationship between Task.Assignment and Employee that uses the Owner field. There are two other relationships between these objects but they don't use the field you are interested in lookup up.
You could create a relationship between them and use the Owner field in Task.Assignment equal to LoginId in employee. However this would be subject to problems if an employee's LoginId can change. However, if the new relationship's name was 'TaskAssignmentAssocEmployee' then you could use the expression: [Employee#.TaskAssignmentAssocEmployee]DisplayName to reference the Task.Assignment Owner's DisplayName.
Another way to do lookups is through the use of Link fields. There is a field called OwnerLink on Task.Assignment, but it does not appear to be used. But, if it were populated with values, you could use the syntax: [link:OwnerLink]DisplayName
Check out the help page titled 'Using Field References' (end of the URL is /help/admin/index.html#reference/expressions/field_references.htm) for more info. It contains information on absolute references (rather than the normal relative references) and the ability to reference the value of a field before the current transaction using the :orginal specifier.
thanks for your comment, I will certainly check the Help pages you indicated.