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 do I use a form of to collect data and allow users to update data

    Asked by BradleySlavik on May 08, 2015 at 12:20 PM

    I would like to use a wonderful form that I created on JotForm on my web site.

    I am collecting contact information, names of children, etc. of classmates.

    When someone fills out the form I want to save it to a local MySql database.

    So far, looks pretty easy.

    I also want to send them an email with a passcode when they fill out the form.

    If they come to different page on my site and give me their email and the passcode, I want to present them with the form already filled in with their previous answers so they can update it or continue filling it out.

    The only part that has me stumped, is how to prefill the form. Is there any kind of API that I should be hooking into? Or should I just write a Javascript AJAX style function that goes over the form after loading and fills out all the fields with answers from the database (if available)?

    Thanks for your consideration.

    and allow update data collect
  • Profile Image
    JotForm Support

    Answered by ashwin_d on May 08, 2015 at 12:58 PM

    Hello BradleySlavik,

    I I understand your basic requirement, you want to allow your users to be able to edit their own submission data. Is that correct?

    Yes it is possible to achieve your requirement. You do not have to use any API to do this but you should actually add {edit_link} tag in your form's auto-responder email alert. When the user submits the form, they will receive the autoresponder email which will have a clickable link. Clicking on this link will take user to same form with submission data already populated. You may like to take a look at the following guide which should help you achieve this:  http://www.jotform.com/help/40-How-to-Let-Users-Update-Their-Form-Submissions-at-a-Later-Date 

    I have moved your question related to MySQL to a separate thread and you will be answered here:  http://www.jotform.com/answers/566596 

    Hope this answers your query. 

    Do get back to us if you have any questions.

    Thank you!