Can Jotform "preselect" form information from database based on user ID

  • Profile Image
    Paul Glover 
    Asked on December 02, 2020 at 05:34 PM

    Hi

    We are wishing to design a COVID safe Event Registration form for our members.

    We would like to do this from a QR code, have the member input their Name or ID, & have their "personal" information prepopulate the form, prior to their registering for that Event.


    Can you advise if / how Jotform could do this, please ?

    Paul Glover

    Qld Sea Kayak Club

    Brisbane

    Australia.

  • Profile Image
    Elton
    Answered on December 02, 2020 at 08:47 PM

    That's possible through Spreadsheet to Form Widget. The spreadsheet containing the user's data will serve as your database. By entering the ID that is in the spreadsheet, it would populate the fields once the ID matches in the spreadsheet record.

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

    If you need further assistance, let us know.

  • Profile Image
    TwoStrongHands
    Answered on December 02, 2020 at 09:00 PM
    Thank You !
    Is it possible to get a copy of spreadsheet used in the Sales Lead demo in this guide, please?
    Paul G
    Paul Glover
    ________________________________
    ...
  • Profile Image
    Girish
    Answered on December 02, 2020 at 10:45 PM

    Yes, you can click the "Download" link as shown in this guide to download the spreadsheet:

    1606967140_5fc85f646e814_0312_5.png

    I hope this helps.