Hi,
I would like to create a search field inside a form using a text field. I found a video with the exact action that I want to do (https://www.youtube.com/watch?v=XgkfTpXTYBc). It's basically scanning a QR code and it will automatically get the exact data from another table.
Could you please help me on this? Thank you so much in advance.
Hi,
I managed to create the QR code using Formula Text, but what I need to do is to have a Text Field that can scan the QR code then display the details of the QR ID like the product name, manufacturer, etc. You can refer to this Youtube video: https://youtu.be/XgkfTpXTYBc?t=113
Qrew LegendWell if you want to be able to scan a QR barcode and have a record display then you would have to use a URL to display the record. Do you need help with a syntax to make a button to display a record?
it would be be like
URLRoot() & "db/" & Dbid() & "?a=dr&rid=" & [Record ID#]
Qrew LegendI'm not sure exactly what your question is but here is some syntax for a Formula Text field to generate a printed QR code for the field called [Item #]
"<img src='http://chart.googleapis.com/chart?cht=qr&chs=240x240&chl="
& URLEncode([Item #]) & "'>"
and here is another one to try
"<img src=https://quickchart.io/chart?cht=qr&chs=150x150&chl=" & URLEncode([Item #]) & "</a>"
