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

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.

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.

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
________________________________
...

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

I hope this helps.