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