LINKTOROW not navigating as configured

AppSheet AppSheet Q&A
1

I have a LINKTOROW action configured to navigate to a specific record from a detail view (Form A) that does not contain an identifier I can use to find the correct record in the destination detail view (Form B or “drop_site_header_detail_mn”). I’ve confirmed the data does exist for the filters but the system doesn’t seem to be able to find the correct record and defaults to the 1st record in the table. Below is the expression. Not sure what I’m missing. Any thoughts? Thanks so much!

LINKTOROW(

MAXROW(

“drop_site_header”,

“date_entered”,

AND(

[cms_sites_id]=[_THISROW].[cms_sites_id],

[drop_route_hdr_id]=USERSETTINGS(route_id),

[site_completed]=0,

[employee_id]=USERSETTINGS(created_by)

)

),

“drop_site_header_detail_mn”

)

2

Just to see what might be happening, have you confirmed the MAXROW part of your expression returns the correct key value?

2 Likes