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.

  • Profile Image
    RubysResidences
    Asked on October 18, 2015 at 08: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.

  • Profile Image
    BDAVID
    Answered on October 18, 2015 at 02:06 PM

    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:

    How to get compressed source code through Embed Form Wizard

    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.