Is this possible with spreadsheet to form widget?

  • landmarkgroup
    Asked on February 17, 2025 at 4:53 AM
    Is there a way where we can store a table with login email id and password and my jotform can only be accessed if user enters correct ID and password
  • Karlo JotForm Support
    Replied on February 17, 2025 at 4:56 AM

    Hi landmarkgroup,

    Using the login and password in your form is a violation of our Terms of Use. But as a workaround, we have a Spreadsheet to Form Widget that you can use to import your data. Let me show you how to use it:

    1. Create a spreadsheet with your data structured like you see below. Make sure that the column names in the spreadsheet match the field names on the form, and include a unique column, like an ID, so the data can be distinguished.

    Is this possible with spreadsheet to form widget? Image 1 Screenshot 50

    2. In Form Builder, click on the Add Form Element menu on the left side of the page.

    3. Click on the Widgets tab, search for the Spreadsheet to Form widget and add it to your form.

    4. In the menu on the right side of the page, upload your data file. (You can simply drag & drop your excel file to the Upload File area.) 

    Is this possible with spreadsheet to form widget? Image 2 Screenshot 61

    5. Then, click on the Downward Arrow icon in the Access Code Column option and select the unique column.

    6. You can also customize texts used in the widget. After you complete everything, click on the Update Widget button at the bottom right of the menu.

    Is this possible with spreadsheet to form widget? Image 3 Screenshot 72 Now, when people fill out your form and enter the unique code from the spreadsheet, the corresponding fields will automatically populate when they click Auto Complete Fields. Check out my screencast below to see how it works:

    Is this possible with spreadsheet to form widget? Image 4 Screenshot 83 Give it a try and let us know if you need any help.

Your Answer