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

  • Paul Glover
    Asked on December 2, 2020 at 5:34 PM


    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



  • Elton Support Team Lead
    Replied on December 2, 2020 at 8: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.


    If you need further assistance, let us know.

  • TwoStrongHands
    Replied on December 2, 2020 at 9: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
  • Girish JotForm Support
    Replied on December 2, 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 Screenshot 10

    I hope this helps.