Can you repopulate one form with data that has previously been entered into another form?

  • Profile Image
    Michael Reade
    Asked on February 24, 2016 at 04:54 AM

    Hello,

    Is it possible to repopulate one form with details that have already been submitted in another form to cut down on data entry?

    Here's the situation:

    I ask academics to apply for grant funding via this form:

    https://form.jotformeu.com/60353612863353

    Over a year later we ask people who were successful to complete an Impact Report via this form:

    https://form.jotformeu.com/50824081567356

    As you can see the fields in Sections 1 and 2 are the same, e.g "First Name", "Family Name", "email"

     

    Thanks for your help.

    Michael Reade
    Grand Challenges, OVPR,
    University College London

     

  • Profile Image
    Charlie
    Answered on February 24, 2016 at 09:45 AM

    You can only prepopulate when it's a new submission and if you have setup form 1 to have a custom prepopulated link for form 2. 

    Here's a guide about it: http://www.jotform.com/help/351-How-to-automatically-pass-form-data-to-another-form 

    However, if you have not setup form 1 that way, then the only way that I can think of that you can prepopulate the 2nd form based on the existing submission data on form 1 is using the API to fetch data. You'll need to create or hire a developer to have a custom script that will automatically prepopulate form 2.

    Here's the specific section in our API documentation about fetching submission data: http://api.jotform.com/docs/#submission-id 

    I hope that gives you an idea on how to proceed.