Execution failure when fetching a Name field from another app
In creator I have one app [Employee Directory] with a form [Employees]. One of the fields is a name field called [Name].
Here is a sample that works, if executed from the Employees app:
- test_Employee = Employees[Name.first_name == "Alex"];
- info test_Employee.Name;
If I go to another app, say our task management app where that employee record is referenced using a lookup field in the form [Task] using the field [Employee_Assigned]. This throws a fatal execution error with no explanation:
- test_Task = Task[Number == "00012"];
- info test_Task.Employee_Assigned.Name;
Also if I try to get Name.first_name or Name.last_name, it returns [null] (which is not correct, the Name field has a value).
What is really interesting, it allows me to fetch other fields from [Employee_Assigned] as long as they are not name fields! Has anyone else had this issue fetching a Name?
- test_Task = Task[Number == "00012"];
- // below returns null
- info test_Task.Employee_Assigned.Name.first_name;
- // below returns null
- info test_Task.Employee_Assigned.Name.last_name;
- // below causes execution error
- info test_Task.Employee_Assigned.Name;
- // below works fine
- info test_Task.Employee_Assigned.Email1;
- // below works fine
- info test_Task.Employee_Assigned.Personal_Cell;