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 can I pre-fill a field based on a database ?

    Asked by corporatevents on May 05, 2017 at 05:42 AM

    Hi Jotform Team,

    Here is my challenge : is it possible in a field "My id" to put an id code (lets say a numeric value of three digits) and in response in a another field "My name is" to see the name linked to the id code ?

    My objectif is to make my users'lives easier and thus when they have to fullfill a form, if they put an id code of 3 digits all there personal datas will be automatically pre filled in the form.

    I cross my fingers and hope you will be able to help me :-)

    Gerard

  • Profile Image
    JotForm Support

    Answered by liyam on May 05, 2017 at 07:29 AM

    Hello,

    If the data is coming from your own database, unfortunately this is not possible within JotForm. You will need to get your form's full HTML source and create an AJAX code that will do this. Perhaps we can assist you provided that we have information on how to access your own database.

    But if you are trying to get the source of information based on your submissions page of your form, this is not possible.

    Please let us know if you have additional questions.

    Thanks.

  • Profile Image

    Answered by corporatevents on May 05, 2017 at 09:13 AM

    Thanks Liyam,

    I would like to stay in the jotform context, more convenient for me, can we not imagine one simple form "A" to create a db with the datas I need and then a form "B" to read those datas, and the results would be placed in a 3trd db ?

    Or with the Google sheet ? can we not read the data I saw a widget wich work with Google sheet.

    What do you think ?

  • Profile Image
    JotForm Support

    Answered by Kiran on May 05, 2017 at 10:39 AM

    Unforutnately, it is not possible to read data from external sources unless it is embedded using the source code and custom scripts as mentioned by our colleague in the previous post. 

    At this moment, it is only possible to send the form data to Google spreadsheet or MySQL database. We may be able to provide some help if you want to use the source code to an external database. You may also hire a programmer from Upwork or Freelancer to achieve your requirement.  

    Thanks!

  • Profile Image

    Answered by corporatevents on May 08, 2017 at 03:42 AM

    Thanks Kiran,

    Yes I would like  to have some help to use the source code with an external database. Can you provided me some information with that ?

  • Profile Image

    Answered by Sven on May 08, 2017 at 03:51 AM

    Hi, 

    Please refer to the links below, they will explain how to your form data, and send it to your external database:

    How-to-Post-Submission-Data-to-Thank-You-Page

    How-to-send-Submissions-to-Your-MySQL-Database-Using-PHP

     

    Thank you!