Scanning QR codes

AlanW

Hello everybody!

Ive got a QR code that has 3 lines of text, and when scanning it, they are merged into one string w/o spaces. Is there somehow I can scan the code, so that the 3 lines are put into 3 different columns instead of them being put into one column as one string?

Andrée Starå

Hi @AlanW

One possible workaround could be to use the URL-Query feature and add the information to a form.

1. Scan QR code
2. The form opens with the fields/columns pre-filed
3. Gets added to the sheet in multiple columns

Would that work/help?

I hope that helps!

Be safe and have a fantastic week!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!

Jake Gustafson

Has there been any improvements with the QR Code scanning functionality? If I'm not mistaken, the scanning option is only available on the app, not through the full web version, right?

My scenario is trying to populate a Form with multiple fields based on a QR Code to minimize the manual entry points of data and reduce the potential for human error. We are a manufacturing company with Part Numbers, Descriptions, Work Order Number, Warehouse, and possibly a few more constant parameters that we'd like to be able to scan that QR Code, populate those 4-5 fields on the Form, then the user could enter the free text options and any other remaining fields before submitting.

So far we had been talking about scanning barcodes for individual items, but we don't have barcodes accompanying all of these variables, maybe half of them. So trying to reduce the individual scans and total manual activities.

Appreciate any thoughts, advice, or full blown solutions. Right now we are developing the sheet, reports, and form associated with this process, so we aren't locked into anything particular, lots of flexibility to adjust as needed.

I found Use a URL query string to specify different default values for a form | Smartsheet Learning Center, but I'm not sure it'll allow for populating multiple fields at once.

Andrée Starå

Hi @Jake Gustafson

I hope you're well and safe!

Regarding

I found Use a URL query string to specify different default values for a form | Smartsheet Learning Center, but I'm not sure it'll allow for populating multiple fields at once.

• Yes, it supports multiple fields.

To include multiple fields in the URL, join them with an ampersand. For example, use:

https://app.smartsheet.com/b/form/6145a2c33c4e42e68bf53900e4a4845b?Rep=Sally%20Smart&ECA=sallysmart@smartsheet.com.

I hope that helps!

Be safe and have a fantastic week!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

Jake Gustafson

Thank you @Andrée Starå, that was exactly what I was looking for. I was able to create a test URL with the form we are working with. Now we'll see what we can autogenerate for users to simply scan a QR and prepopulate a big portion of the form.

Andrée Starå

@Jake Gustafson

Excellent!

You're more than welcome!

I developed a client solution recently with a structure in Smartsheet for each manufacturing step and then pasted those codes in a Google Sheet to create the QR Codes for print.