I have this expression in my SHOW column.
The language is taken from a paper from.
“I " & [Inspected By] & " declare that the abovementioned goods were inspected by me as per the inspection form on the reverse side to this document and I declare to undertake the following actions (mark with an X):”
The [Inspected By] column is a reference column. In the drop down for the question inspected by I get the names rather than their unique IDs.
But in the declaration above I get the Unique Ids. How do I get the declaration to show the name and not the ID?
The [Inspected by] is not the label or key.