Appsheet QR integration

[puneetkoul]

Hi There,

I am trying make a Meeting room In Out App in Appsheet. I am trying to add a field e.g Scan QR code of the meeting room. The QR code should be dynamic and scannable in the APP which depicts the upcoming slots available to access the meeting room. 

I have created a field and used CONCATENATE("https://chart.googleapis.com/chart?chs=150X150&cht=qr&chl=",<Fieldnames>)

The field is 'IS Scannable' and Type is image as well. But while saving I am receiving the error as :-

Column Name 'QR Code' in Schema 'Employee ID_Schema' cannot be scanned (not Barcode scannable) because its Column Type is 'Image'

As I searched in the internet the Column Type is required as Image for Barcode depiction in the app.

Please suggest.

@exelaswapneel @appsheet 

[lynchk21]

Hello - a few things I noticed, and please correct me if I am wrong:

First - I would avoid using https://chart.googleapis.com/chart?chs=150X150&cht=qr&chl= as it has been discontinued. There are other options, one of which is https://api.qrserver.com/v1/create-qr-code/?size=150x150&qzone=5&data=

Second - Your column should be in [ ] brackets, not < > i.e. [fieldnames] 

Lastly, what type of column is [Fieldnames]? Curious what type of information you are encoding in the QR code

[puneetkoul]

Thanks for your reply. I will try with the given api. Yes the fields should be noted with []. In the [Fieldnames] I am trying to extract any field information with the QR in addition.

[puneetkoul]

Hi There,

I tried the given solution but still an error is being thrown as :-

The Column QR code is Image as suggested in different forums. 

[xeonavn]

Try this API try this API, it works for me. "CONCATENATE("https://quickchart.io/qr?text=", ENCODEURL([Text to Generate]))"

[puneetkoul]

Thanks Again, The error I am receiving is below on UX.

[xeonavn]

You Need to have this field where the details for QR code that need to generate.

[michellelee]

Thank you very much. I followed your suggestion and successfully completed it.