- thyrocareAsked on June 24, 2014 at 03:10 AM
I want to collect the data from my database is it possible to do that? like automatically fills the name who is using and cant able to edit.
- JotForm SupportjonathanAnswered on June 24, 2014 at 04:57 AM
Unfortunately there is no direct method to import data from databases and pre-populate the form fields.
BUT what you can do instead is Import Data into your form's submission data using the Import Data App
You may need to export first your database data to a flat file like CSV so that you can use the flat file to import the data into JotForm submission data.
Currently, you can also pre-populate your form's fields with data manually before the form respondent can fill the form.
You can use the Field Prepopulator App to do this.
Or using the URL parameter method of the form. Check this user guide
Hope this help. Inform us if you need further assistance.
- mandarpatil09Answered on June 24, 2014 at 05:15 AM
Can i able to add my code in the form?
so that i can use it on my website and i can link it
- JotForm SupportjonathanAnswered on June 24, 2014 at 05:38 AM
I am not quite sure how you meant on your latest message, but you can use the form's full source code embed on your website also (in case this was what you were looking for)
User Guide: -How-to-get-the-Full-Source-Code-of-your-Form
Actually, if you have programming skill or resource you can also create your own custom program using server side code like PHP to automate the pre-population of the form fields coming from the database.
You can make use of the form's full source code to inject your own custom code to add functionality to the form.
- JotForm SupportjonathanAnswered on June 24, 2014 at 08:44 AM
I have created a new separate post for the new question here
We will respond to you on the new post.
- JotForm SupportWelvinAnswered on June 24, 2014 at 08:46 AM
I'm not sure if you can pull data from your database and put it as an options to your form using our API, but I am sure that is possible using PHP programming. Unfortunately, I couldn't make an example for you.
For now, you may consider using our Auto Complete widget: http://widgets.jotform.com/widget/autocomp. You can manually add the list to the settings, submitters shouldn't be able to edit the names.