Expression not working for specific item view

[CwardTK]

I know this has been asked before repeatedly but I can't seem to get the QR Code expression to generate the QR code that goes directly to the item in my Inventory app. 

I'm working off of the pre-generated expression that opens to the app item list, but not into the specific item.

"https://zxing.org/w/chart?cht=qr&chs=350x350&chld=L&choe=UTF-8&chl=https://www.appsheet.com/start/(m... app id )#view=Items_Detail"

Now, I have "Description" in my data source, but not "Items_Detail", when I change to "Description", the expression still doesn't work...

[jballester]

Hi, 

try moving the formula from "show field" to "initial value".

https://www.googlecloudcommunity.com/gc/Tips-Tricks/Scan-barcode-with-your-native-mobile-camera-and-...

[CwardTK]

Hello!

Thank you for your reply, but I am unable to move the formula to the initial value since the row is a virtual column. **I meant Virtual Row

[Steve]

---

@CwardTK wrote:

the row is a virtual column

---

Not possible.

[CwardTK]

What do you mean?... The Barcode row can't be a virtual row? or moving the expression to the initial value is not a possible? 

[Steve]

A row is a row, a column is a column. A row cannot be a column and a column cannot be a row. There is no such thing as a "virtual row".

[CwardTK · Accepted solution]

I figured it out! So, if anyone runs into this issue and wants to do the same thing with a QR code...

CONCATENATE(
"https://api.qrserver.com/v1/create-qr-code/?data=",
ENCODEURL(CONCATENATE(
"https://www.appsheet.com/start/InsertYourAppID#appName=InsertYourAppName&row=",
[_THISROW].[Item ID],
"&view=Items_Detail"
))
)

[Steve]

Nicely done!