QR Code Generation

%3CLINGO-SUB%20id%3D%22lingo-sub-1871962%22%20slang%3D%22en-US%22%3EQR%20Code%20Generation%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1871962%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20There%2C%3C%2FP%3E%3CP%3EI'm%20trying%20to%20create%20a%20list%20of%20credentials%20for%20our%20MDM%20control%20software%20to%20onboard%20new%20tablets.%20Currently%20I%20use%20some%20VBA%20in%20excel%20to%20generate%20a%20QR%20code%20from%20goqr.me%20(could%20easily%20use%20google%20api%20too)%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIn%20my%20Sharepoint%20list%20i%20have%20a%20few%20columns.%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20the%20username%20for%20the%20site%20and%20the%20password%20for%20the%20site%2C%20i%20would%20like%20a%20column%20that%20auto%20generates%20the%20URL%20for%20the%20QR%20code.%3C%2FP%3E%3CP%3EProblem%20i'm%20having%20is%20all%20the%20tutorials%20i%20can%20find%20use%20concat%20but%20the%20URL%20i'm%20trying%20to%20generate%20has%20a%20bunch%20of%20quotation%20marks%20in%20it%20for%20the%20MDM%20software%20to%20understand%20how%20to%20enroll%20the%20tablet.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ESo%20i%20suppose%20my%20question%20is%2C%20What%20formula%20would%20i%20need%20to%20generate%20a%20string%20with%20quotation%20marks%20and%20information%20from%202%20columns%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EE.g.%20%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CPRE%20class%3D%22lia-code-sample%20language-html%22%3E%3CCODE%3Ehttps%3A%2F%2Fapi.qrserver.com%2Fv1%2Fcreate-qr-code%2F%3Fsize%3D150x150%26amp%3Bdata%3D%7B%22googleplaystoreurl%22%3A%22appurl.apk%22%2C%22MDMusername%22%3A%22%5BINSERT%20USERNAME%20HERE%5D%22%7D%3C%2FCODE%3E%3C%2FPRE%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1871962%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ELists%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ESharePoint%20Online%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Occasional Visitor

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]"}

 

0 Replies