How can I pre-fill a field based on a database ?

  • Profile Image
    corporatevents
    Asked 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
    liyam
    Answered 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
    corporatevents
    Answered 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
    Kiran
    Answered 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
    corporatevents
    Answered 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
    Sven
    Answered 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!