I have a table called Guest Passes, keyed by a text column called ‘Pass ID’ which gets assigned a UNIQUEID() value for each pass. Guests are assigned that Pass ID when they request a pass.
As a guest checks in I enter the pass ID they present in another table. The column in that table is also called Pass ID. An action is then triggered which uses LINKTOROW to show the guest pass for that Pass ID in the Guest Passes table.
The expression for the action is LINKTOROW([Pass ID],“Guest Passes”).
The column type for the Pass ID columns in both tables is text, in the app and on the spreadsheet.
The problem is that invoking that action shows me all rows in the Guest Passes table, not just the row I want. I’m sure I’m doing something wrong - but what?