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.

  • RubysResidences
    Asked on October 18, 2015 at 8:49 AM

    Hi there,

    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?

    Thanks.

  • David JotForm Support Manager
    Replied on October 18, 2015 at 2:06 PM

    Just to let you know, we have integrated payment gateways you can use.

    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 Screenshot 30

    Please check this guide to setup your first order form: https://www.jotform.com/help/165-Setting-Up-Your-First-Order-Form

    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 Screenshot 41

    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:

    How to get compressed source code through Embed Form Wizard Screenshot 52

    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.