How do I use a form of to collect data and allow users to update data

  • Profile Image
    Asked 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.

  • Profile Image
    Answered 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: 

    I have moved your question related to MySQL to a separate thread and you will be answered here: 

    Hope this answers your query. 

    Do get back to us if you have any questions.

    Thank you!