JotForm is a free online form builder which helps you create online forms without writing a single line of code. No sign-up required.
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.
I need to create a Booking form, where, once a 'product' is selected from a drop down list, the price comes from a database and fills the cost field.Asked by RubysResidences on October 18, 2015 at 08:49 AM
I need to create a Booking form, where, once a 'product' is selected from a drop down list, the price comes from a database and fills the cost field. All cost fields will come from a database. I am hoping to create this database from another form I created here. Is this all possible?
On the provided webpage, the costs will be at the bottom of the page, and payment will have to be made before hitting the Submit button. Once they enter the Registered Property on the top line, the price for the selected services (one of which will be particular to that specific property) will have to pop up at the bottom, in an invoice format.
Is this all possible?
Just to let you know, we have integrated payment gateways you can use.
Please check this guide to setup your first order form: https://www.jotform.com/help/165-Setting-Up-Your-First-Order-Form
Here is another useful guide: https://www.jotform.com/help/225-How-to-add-options-to-Payment-Forms
But, if none of these suites your needs, and you want to proceed with your own custom prices from your database, then, that will required you to download the full source code:
Hire a programmer, if you do not have experience, to do the coding to connect the form with the database and do the queries to pull the data from the database to the form with the programming logic that goes according to your needs.