Display Value of a Ref table

[Driller]

I have a form where two columns reference a staff list table.

They obviously need to reference the Key in the employee table (which is a auto Unique ID)......but how do I change the DISPLAYED value to the NAME of the employee.......see below screenshot.....not much use displaying the unique ID.....

[dbaum]

Add row labels - AppSheet Help 

[Driller]

Hi dbaum, 

Name is already selected as the Label. The Name shows everywhere else I need it too except for in the Spreadsheet Data and also when the Data is exported into a PDF template.

Anyway around it?

[dbaum]

I see. I assumed your screenshot was from the app UI. I realize now it's probably from an output (e.g., email or file) created via an automation. As @Marc_Dillon noted, use a dereference expression in the template for the output. For example:

[Driller].[Name]

[Marc_Dillon]

https://help.appsheet.com/en/articles/1090811-dereference-expressions

[Driller]

Hmmm.....does this mean I will need to add another column to take the Dereferenced value? Thats doable I guess.....I can hide the column which displayes the key.

Thanks, 

[Marc_Dillon]

No, you can just put the dereference expression in the template.