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

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

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.

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 ?

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!

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 ?

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!