Announcements
The Google Cloud Community will be in read-only from July 16 - July 22 as we migrate to a new platform; refer to this community post for more details.

Concatenar texto con codigo QR

Hola,

Tengo una columna virtual que genera el siguiente codigo QR del part number de cada producto.

CONCATENATE("https://chart.googleapis.com/chart?chs=300x300&cht=qr&chl="&ENCODEURL([PART NUMBER]))

unnamed.png

Como hago para que coloque arriba o debajo del codigo el part Number en texto?
Dejo una imagen editada como ejemplo

unname1d.jpg

Gracias.

 

 

Solved Solved
0 2 430
1 ACCEPTED SOLUTION

JSO
Silver 2
Silver 2

Try something similar to this:


My Config table has the fields:
ConfNombreEmpresa of type Text, contains a text

GenerarQR (virtual) of type Image (will generate the QR), with AppFormula:
LINKURL("https://quickchart.io/qr?text=" & ENCODEURL([ConfNombreEmpresa]) )


PruebaTextQR  (virtual) of type LongText and Formatting HTML (will generate the QR with the text above) , with AppFormula:
"<p>" & [SetCompanyName] & "</p>" &
"<img src=" & [GenerateQR] & ">"

JSO_0-1690194169189.png

Hope this can help you

 

View solution in original post

2 REPLIES 2

JSO
Silver 2
Silver 2

Try something similar to this:


My Config table has the fields:
ConfNombreEmpresa of type Text, contains a text

GenerarQR (virtual) of type Image (will generate the QR), with AppFormula:
LINKURL("https://quickchart.io/qr?text=" & ENCODEURL([ConfNombreEmpresa]) )


PruebaTextQR  (virtual) of type LongText and Formatting HTML (will generate the QR with the text above) , with AppFormula:
"<p>" & [SetCompanyName] & "</p>" &
"<img src=" & [GenerateQR] & ">"

JSO_0-1690194169189.png

Hope this can help you

 

Thanks! @JSO 

Top Labels in this Space