LINKTOROW question. I have a table called Gu...

expressions
(Joseph Pentheroudakis) #1

LINKTOROW question.

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?

Thank you!

(Steven Coile) #2

The view name you supply to linktorow() should be a detail or form view, not a table or deck (or any other) view. I’m guessing Guest Passes is a table view?

(Joseph Pentheroudakis) #3

@Steven_Coile thank you- that worked!