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

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

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.

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 

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.

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

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!