QR Code in generated Document

Alexander Sullivan

Hi,

We have been using the Smartsheet Document Generator to create Work Orders (Travel Ticket) to get processed on shop floor.

Is there a way to have a Qr code imbedded when the Document is generated so my guys can scan the Ticket with the search function on the Smartsheet app.

Work order Column = QR code

Garrett Henke

@Alexander Sullivan We have done something very similar using Bridge to add QR codes to a sheet. We have linked QR codes to form as well as specific rows on a sheet. For your case you can use Bridge to connect to a QR code generator API,

• Use the Get Row function to get the rows permalink
• Use the permalink reference in the Compose Text
• Generate the QR Code
• Add the image to the cell

You may need to contact Bridge Support to help build out the customizations, but it is possible. Here is an example of our workflow

Andrée Starå

Hi @Alexander Sullivan

I hope you're well and safe!

Here's a possible workaround or workarounds

• I've developed a solution in Smartsheet / Google Sheets to create URL queries and QR codes.

My solution is for different steps in a manufacturing process to measure the time.

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 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!

Andrée Starå

@Garrett Henke

Nice solution!

Thanks for sharing!

Kelly Moore

Hey @Garrett Henke

This is exactly a solution I'm looking for and I'm a bridge user. Is it possible to see the expanded steps beginning with your String Tools?

Thanks for any help

Kelly

Garrett Henke

@Kelly Moore Here are the steps:

Trigger: When Rows Are Added

Startstate value

Smartsheet: Get Row -> getting the sheet ID as well as the event ID (my case is the row ID). Under advanced options you want to check 'Include Columns' as well as 'Include Row Permanent Link'

String Tools: Compose Text -> for my case I am linking the QR code to a form so that foremen can scan and acknowledge that the items were picked up by them. Therefore I have cleared the hyperlink to the form since this is a live link. I did add {{states.startstate.smartsheet.get_row.row.cells.Pick Ticket ID.displayValue}} to automatically populate the Pick Ticket ID to the form.

For the case above I would use the Get Row to grab the rows permalink. If you copy the data reference for the permalink and put that directly into the QR Code Generate step and completely skip this step.

QR Code Generate -> value will be your permalink (this was a custom built, however you could use a HTTP utility call to send the link to a QR Code website with an open API to generate the QR code)

Smartsheet X: Add image To Cell -> select the column ID, Image, and File Name (this was also custom made

If you are familiar with the API, this step is the Bridge equivalent of 'Add Image to Cell' (look at Cell Images Methods/Objects within the API docs)

I am happy to answer any additional questions! Hope this helps!

Lindsay Whitbread

These are some cool solutions suggested here - very nice!

We've had a few Smartsheet customers come to us for help getting QR codes to generate automatically. Most of those customers aren't looking to get into the technical detail and just need something set up for them to get the job done. We've got a QR code addon for Smartsheet ready to go for customers that aren't looking to create the solution by themselves so please email our team if you're interested in that.

MaaikMeijerink

hi @Lindsay Whitbread ,

yes, had the same questions from customers asking me a less technical solution for generating QR codes even without Bridge, but also keeping them up to date when content changes.

Our dev team came up with the idea 💡 to use formula’s which (if a little familiar with Smartsheet) are quite easy to use: just wandering if you have done the same: check: https://www.smartsheet.com/marketplace/apps/inline-qr-generator