QR Code in generated Document

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


Answers

  • Garrett Henke
    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å
    Andrée Starå ✭✭✭✭✭✭
    edited 09/28/21

    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!

    SMARTSHEET EXPERT CONSULTANT & PARTNER

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

    W: www.workbold.com | E:[email protected] | P: +46 (0) - 72 - 510 99 35

    Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.

  • Andrée Starå
    Andrée Starå ✭✭✭✭✭✭

    @Garrett Henke

    Nice solution!

    Thanks for sharing!

    SMARTSHEET EXPERT CONSULTANT & PARTNER

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

    W: www.workbold.com | E:[email protected] | P: +46 (0) - 72 - 510 99 35

    Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.

  • Kelly Moore
    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
    Garrett Henke ✭✭✭✭✭
    edited 02/03/22

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

  • 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.

    Smartsheet Lead @ InfoSpark

    2023 Asia Pacific Smartsheet Partner of the Year

    Platinum Smartsheet Partner | www.infospark.com.au

  • 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

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!