I have this formula in google sheets which ge...

(Ian Townson) #1

I have this formula in google sheets which generates a barcode and works perfectly. My issue is, how do I get that barcode to then show up inside the app?

=image(“http://www.barcodesinc.com/generator/image.php?code=” & G2 & V2 & H2 & V2 & J2 & “&style=197&type=C128B&width=300&height=50&xres=1&font=3”, 3)

Kind regards Ian Townson

(Aleksi Alkio) #2

You need to create a virtual column with the Show/Image type. Then add your URL for content and it should work.

(Dinh Nguyen Nguyen) #3

@Ian_Townson For the barcode image to show up in the app, it must be saved to Google Drive, and the image’s URL or relative file path must be saved to the image column.

(Aleksi Alkio) #4

This is a dynamic barcode in the form view.

(Aleksi Alkio) #5

To achieve the same with the app formula, you need to create the link for the barcode with the CONCATENATE expression.

#6

This post discusses a solution to this as well: plus.google.com - Hey AppSheet Community! I found a really cool feature that has helped me out … Hey AppSheet Community! I found a really cool feature that has helped me out … plus.google.com