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

    Is it possible to pre-populate a form with data?

    Asked by Ray on November 25, 2015 at 12:10 PM

    Is it possible to load a form which is pre-populated with data from a data file? For example we wish to pre-populate a form with data that a Client had supplied previously and give them the opportunity to review and make changes before submitting the new version.

    review pre-populated populated
  • Profile Image
    JotForm Support

    Answered by david on November 25, 2015 at 02:51 PM

    Hi,

    Though it is not possible to pre-fill the form from a file, you can ore-fill the form via URL parameters.  Here is our guide on how to do so:

    http://www.jotform.com/help/71-Prepopulating-fields-to-your-JotForm-via-URL-parameters

    The guide has a link to an app that will create the URL for you.  You would then send your client that specific URL to review and update.

    If you have any further questions, let us know and we will be happy to help.

  • Profile Image

    Answered by raytoomer on November 26, 2015 at 07:58 AM

    Hi, Many thanks for your response. I have followed you advice and it works fine. Is it possible to obtain a copy of the completed form URL at submission time (which could subsequently be used to re-populate the form if changes are required ti be submitted). I note is is possible to get php code sent to the Thank You Page  but it is beyond me to turn the code into a URL.

    Thanks.

  • Profile Image
    JotForm Support

    Answered by Charlie on November 26, 2015 at 09:50 AM

    I'm not quite sure if I understand your follow up concern. However, if you wish to have the prepopulated form URL on that "Thank You" page, then that's possible. However, it will create a new submission instead of updating an existing submission.

    If you wish to have a URL that allows you or the user to update or edit an existing submission, then you can add the edit link either on the email template, you can check this guide to learn more about it: http://www.jotform.com/help/40-How-to-Let-Users-Update-Their-Form-Submissions-at-a-Later-Date 

     

     

    Or in the "Thank You" page where your users can see the edit link and copy it for future use.

     

    I hope that helps. If I misunderstood your concern, please do let us know.

  • Profile Image

    Answered by raytoomer on November 26, 2015 at 01:22 PM

    Hi Charlie,

    Your response was spot on and it works fine, many thanks.

    As a follow-on, is it possible include a link to the Excel data within the Autoresponder email template?

    Thanks again.

  • Profile Image

    Answered by Ben on November 26, 2015 at 01:40 PM

    In my colleague's name, you are welcome.

    In regards to your other question, I have moved it to a new thread here: http://www.jotform.com/answers/712618 where we will be answering shortly.