Barcode Scanner: how to pass the result to another field, and then to the Spreadsheet to Form widget?

  • Profile Image
    DevoraG
    Asked on June 26, 2019 at 10:15 AM

    Hi,

    Can you please explain the exact functionality of the barcode scanner widget? 

    Once the scanner reads the barcode, can it save the result in a separate field on the form? 

     

    Thank you!

  • Profile Image
    BDAVID
    Answered on June 26, 2019 at 12:15 PM

    We would be glad to assist you, the functionality of this widget is to scan barcodes, and the information will be visible in the submissions page and/or email notifications.

    Yes, you can save the result in a separate field if you want to, you can use the Form Calculation widget to capture it:

    1561565452capturevalue.png

    Example:

    1561565648scan.gif

    Let us know if you need more help, we will be glad to assist you.

  • Profile Image
    DevoraG
    Answered on June 26, 2019 at 12:22 PM

    Thank you! 

    Now, once I have the result captured in a separate field, can I use that value to populate additional fields, with the Spreadsheet to Form Widget, using the barcode result as the unique identifier? 

     

     

     

  • Profile Image
    BDAVID
    Answered on June 26, 2019 at 01:57 PM

    You are welcome! 

    In regards of passing the value to the Spreadsheet to Form widget, this can be possible through conditions, example: https://www.jotform.com/help/286-How-to-Pass-Field-Value-to-Another-Field

    1561571349value.png

    Explanation: the condition passes the value from my Form Calculation widget called "Value"(which captures the result of the Barcode) into the Spreadsheet to Form widget.

    See how it works:

    1561571653passvalue.gif

    Note: in my example you see an error, because the Barcode result is not listed in the Excel file that is uploaded in my Spreadsheet To Form widget.

    Hope this helps. Let us know if you have more questions.