Trim data scanned by the QR code from an external source

  • Profile Image
    srudick1
    Asked on December 15, 2020 at 12:03 AM

    next question I am trying to read a qr code off of an extenal source. It has more info the i want. how will jotform fill it in and will the info I do not want just go away.


    i want to capture name address , city state for example


    but not zip

  • Profile Image
    Sonnyfer
    Answered on December 15, 2020 at 12:08 AM

    Unfortunately, we have no control over the data being returned to the QR code from an external source. Can you describe the workflow of your form? Perhaps we can suggest a workaround if we understand the way it works.

  • Profile Image
    srudick1
    Answered on December 15, 2020 at 09:24 AM

    I want to capture and set up a fields for below in jot form. Can i jotform qr code reader transfer this to the correct fields in jot form

    first name

    last name

    address

    city

    state

    zip


    the data i am qr coding in also gives height and weight I do not want this info

  • Profile Image
    Jovanne
    Answered on December 15, 2020 at 10:58 AM

    Hi there,

    To my understanding, you wanted to scan a QR code, and after the widget reads the code, it will auto-populate the name, address, city, state, and zip code associated with that QR code.

    I'm afraid it's not possible with the QR code widget as the widget only reads data from the QR code. It does not support trimming of data and populating them into different fields.

    You can use the QR code widget and pair it up with the SpreadSheet to Form widget. Once the QR code widget scans for a unique code, you can copy the scanned code to the Spreadsheet to Form widget. The Spreadsheet to Form widget will then populate the fields from the data on your spreadsheet file tied up with the QR code. Here's a sample output:

    1608047430_5fd8db46b9c16_5.gif


    Related guide: https://www.jotform.com/help/442-how-to-use-the-spreadsheet-to-form-widget


    You can check my demo form to check it for yourself: https://form.jotform.com/203493984839069.

    Kindly use this QR code for the widget to scan:

    1608048165_5fd8de25b658b_qr-code.png

    Please confirm if this workaround works for you so I can guide you through the steps on how to build the form.

    We look forward to your response.

  • Profile Image
    Jovanne
    Answered on December 15, 2020 at 11:03 AM

    Kindly use this QR code for the widget to scan:

    1608048187_5fd8de3b68057_qr-code.png