LINKTOROW - What Am I Missing? I have a view...

expressions
(Midland Freewheelers) #1

LINKTOROW - What Am I Missing?

I have a view called “Record Collection”

This shows only the columns I need for the user to record a collection.

It’s launched from an Action shown on the detail view of a row where the status = “Called Rider”.

I’m using this expression - LINKTOROW([Job number], “Record Collection”)

It correctly goes to the view but the record shown is the first row in my Google Sheet and not the row that I was just looking at.

I’ve tried replacing [Job Number] with [_rownumber] but the same result all the time, it goes to job number 17001 or row number 2.

Is there something else I have to do to get the current job number to display?

I’ve tried this LINKTOROW([Job number]=180696, “Record Collection”)

but it still goes to job 17001

(Aleksi Alkio) #2

LINKTOROW needs the key columns value and I believe your “Job number” is not a key, am I correct?

(Midland Freewheelers) #3

@Aleksi_Alkio yes, you’re correct.

My key is a hidden column called RecordID.

I’ve used that now and it’s working.

Wish the expression builder had thrown an error when I attempted to use a non key column!!!

Anyway, thanks for your help.

Much appreciated.

(Aleksi Alkio) #4

You’re welcome