How to create direct URL links to detail view of lines in a spreadsheet

[awilliams589]

I am trying to figure out how to get appsheet to automatically generate a URL for the detailed view of a specific row in a table and then post that URL into a column on the same row.

If I navigate in the app editor to a specific item in this case as I am using the inventory app template, the editor generates a link to that specific detailed view. 

I can manually paste it into the spreadsheet and it works perfectly and takes me straight to the detailed view of that item.

How do I get appsheet to do this? Seems like a simple task but apparently not an easy one. I have poured over the manual through deep links, etc. and I cant get anything to show up in that column no matter what expression I use, let alone a URL. I read over this post since it seemed somewhat close to what I am trying to do, but I was unable to make any sense of it: https://www.googlecloudcommunity.com/gc/Tips-Tricks/META-POST-Deep-Links-URL-Parameters/m-p/349632 

I am looking to do this since I can use the spreadsheet to print labels with a description and QR code generated by the labeler from the URL (The labeler can take in a CSV and automatically print the whole dataset while simultaneously converting specific column(s) in that data set into a QR code) to attach to each product bin to quickly access the details page for each product to quickly to audit inventory and order more stock.

Thank you.

[Suvrutt_Gurjar]

If understanding of your requirement is correct, please try an expression as follows in the URL type column's app formula setting

CONCATENATE("https://www.appsheet.com/start/190db37f-7f30-4175-b10f-19270495b156#view=Orders_Detail","&row=", [Key column of table])

You will get the bold part in highlighted in blue of the above concatenate expression in the detail view as highlighted in yellow below

Please concatenate it with &row=", [Key column of table]

as I have shown in the concatenate expression above.

[mksh]

You can probably use LINKTOROW().