What is JotForm?
JotForm is a free online form builder which helps you create online forms without writing a single line of code. No sign-up required.

At JotForm, we want to make sure that you’re getting the online form builder help that you need. Our friendly customer support team is available 24/7.

We believe that if one user has a question, there could be more users who may have the same question. This is why many of our support forum threads are public and available to be searched and viewed. If you’d like help immediately, feel free to search for a similar question, or submit your question or concern.


  • Profile Image

    How to autopopulate a form

    Asked by luyi zhang  on April 19, 2016 at 09:24 AM

    Hi,

    I was wondering if there's a way to use the information from a file upload to auto populate the fields on the form? or to populate a spreadsheet widget. 

    thanks, 

     

     

    template thanks spreadsheet widget information OR prepopulate
  • Profile Image

    Answered by victor on April 19, 2016 at 09:50 AM

    There are currently two ways to populate a form:

    a) If you would like the fields to have a default value, you may use our Propopulate app. You may be able to set default values for each or any field you like. This values will always be displayed when users open the form

    b) The other option is to use the URL to populate fields (Prepopulating fields to your JotForm via URL parameters). If you have an excel with the values, you can just create the URL using a formula

    Once you have the URL, you can open the form with it

    Please let us know if this helps