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

  • Paul Glover
    Answered on December 02, 2020 05: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 JotForm Support
    Answered on December 02, 2020 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.


    If you need further assistance, let us know.

  • TwoStrongHands
    Answered on December 02, 2020 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
  • Girish JotForm Support
    Answered on December 02, 2020 10:45 PM

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

    1606967140 5fc85f646e814 0312 5 Screenshot 0

    I hope this helps.