Nov 10 2020 06:39 AM
Hi There,
I'm trying to create a list of credentials for our MDM control software to onboard new tablets. Currently I use some VBA in excel to generate a QR code from goqr.me (could easily use google api too)
In my Sharepoint list i have a few columns.
I have the username for the site and the password for the site, i would like a column that auto generates the URL for the QR code.
Problem i'm having is all the tutorials i can find use concat but the URL i'm trying to generate has a bunch of quotation marks in it for the MDM software to understand how to enroll the tablet.
So i suppose my question is, What formula would i need to generate a string with quotation marks and information from 2 columns?
E.g.
https://api.qrserver.com/v1/create-qr-code/?size=150x150&data={"googleplaystoreurl":"appurl.apk","MDMusername":"[INSERT USERNAME HERE]"}