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

    Creating a database that allows user input to be saved...

    Asked by objectivedebug on June 02, 2016 at 08:43 AM

    Hello,

    My form currently has a dropdown menu with pre-defined values that are set so an employee can simply select the business name, and then continue to work on the form. However, the small business using this form is constantly going to new business locations and the employees would like to have an option of adding those business names into the dropdown menu selection themselves.

    The only thing I have seen that could link to a database is when the "POST" value is selected on the thank you page. Which of course comes after the "Submit" button has been clicked. I need for there to be a way for the employees to populate the dropdown menu themselves without having to tell me the name of the new business and manually add it to the dropdown menu selections. Is this possible? If so, please tell me how I can set that up.

     

    Thank you,

    Robert

  • Profile Image

    Answered by Huberson on June 02, 2016 at 10:21 AM

    Hi Robert,

    You can either use the Dynamic Textbox Widget to add a simple textbox where they can add business name, or use Configurable list Widget to have more complex dynamic fields.

    Demo: https://form.jotform.com/61534256850961 

     

    You let us know if you need more assistance.

  • Profile Image

    Answered by objectivedebug on June 02, 2016 at 10:27 AM

    Dear Huberson,

    Unfortuntely, I need to allow the employees to build a static database that can grow as they add new business names. That demo didn't appear to allow the employees to access the input that they may have completed...say 4 days ago. As of right now, I have to manually type in the new business names to populate the dropdown menu when a new business hires my company for services. Please let me know if this is possible.

     

    Thank you,

    Robert 

  • Profile Image

    Answered by Huberson on June 02, 2016 at 12:19 PM

    JotForm do not offer an option to automatically pull submitted form data from a database and populate the form fields with that data. But, if you have a database you can send the submitted entries to it, and use some Script to pull the appropriate data and pass it to your form via URL parameters.

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

    Prepopulating-fields-to-your-JotForm-via-URL-parameters

     

     

    If what you need is a sort of application where employee can add data that get registered in a database, and when they open the form those data become available as options ( in a dropdown) in the form fields, I think this is not actually possible.

    In case you have employees that need to fill the form with the flexibility to add new options, you can register for a paid account and have them as sub-users. Anytime they need to add a new business name in the dropdown, they simply log in their sub-account to add that option, then fill the form.

  • Profile Image

    Answered by objectivedebug on June 02, 2016 at 01:12 PM

    Dear Huberson,

    Thank you for your response. I kind of figured that I would ultimately wind up having to allow them a sub user account. I don't want to do so, as they are not computer savvy and will more than likely delete or modify the wrong forms and data. But, I appreciate your help and I will try and allow them a sub user account and hope all goes well.

     

    Thank you,

    Robert

  • Profile Image

    Answered by Huberson on June 02, 2016 at 01:53 PM

    You are welcome Robert! The system is actually pretty easy to use, even if they barely used a computer, as long as they can click and drag adding a new option is pretty simple. If they delete forms/fields or make non-desirable changes, they can be reverted/recovered easily.

    Also, there is a support team here to help them along the way. 

    If you need help with anything else Robert, do not hesitate to contact us.

     

    Thank you!