Table LookUp Using URL Param Not Displaying Name

[sam_646]

OnStart of my app I have:

Set(varRecordToView, Value(Param("ShiftLogID")))

I have a label that displays varRecordToView -

Text code is:

varRecordToView

And I have another label that performs a LookUp on a table to display the CreatorName -

Text code is:

LookUp('OCH Shift Log - Forms Data', FormReference=varRecordToView, CreatorName)

Screenshot of the table:

Screenshot of the app while editing:

All works well in this view, but when I email the link to "play" the app (passing in &ShiftLogID=1 at the end of the URL) I get this:

The label at the top correctly displays 1 which is the param that is passed in the URL, but the name box is blank.

In edit mode it displays the name correctly using the LookUp but when clicking on the link it only correctly displays the number in the top field but not the name which should be "Test Name"

[sam_646 · Accepted solution]

Issue solved, user never had permission to the enviroment