How to prepopulate a form?

  • Nancy Bell
    Asked on March 7, 2018 at 9:08 PM

    Hi I am wondering if your  program would work for me. 

    I have a form that is completed every year ( i need to prepopulate or prefill data from year to year)

    The form is completed in teams. So one form is done by at least 3 people. i have a total of 30 teams. The teams are in different locations so they cannot sit down together and complete one form. 

    I need to be able to easily sort/download in excel for reporting purposes.
  • BJoanna
    Replied on March 8, 2018 at 1:59 AM

    Yes, JotForm would work for you. 

    There are two ways to prepopulate a form:

    1. Via URL parameters, which can be achieved wit prepopulate app - http://prepopulate.jotform.io/ 

    Prepopulating Fields to Your JotForm via URL Parameters

    2. From an external Excel Sheet. This can be archived with Spreadsheet to form widget.

    How to Use the Spreadsheet to Form Widget

    To avoid possible confusion, in case that you have some followup questions, I moved your other questions to a separate thread and we will reply there shortly. 

    https://www.jotform.com/answers/1408628 

    https://www.jotform.com/answers/1408629