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
LINKTOROW needs the key columns value and I believe your “Job number” is not a key, am I correct?
@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.
You’re welcome
User | Count |
---|---|
44 | |
29 | |
22 | |
20 | |
14 |