Ability to pre-set rates and availability for up to 2 years in advance based on dates

  • Profile Image
    KittySmack
    Asked on October 06, 2014 at 12:57 PM
    In addition, ideally, I would love to have the ability to set rates and availability based on dates, up to two years in advance, be able to close room types if sold out, etc.,   but it seems that this would require a database.  Along with the database, I would need a front end that I can update values based on single days, bulk updates based on from - to dates, or from - to dates based on the days of the week, for example, if the from - to dates are sept 1 - dec 31, I may only want to update thursday - saturday dates in this date range.
  • Profile Image
    Kiran
    Answered on October 06, 2014 at 02:32 PM

    This requirement seems that we need to have a custom program to achieve this by using source code of the form. If you have a programming resource, you can create a custom program using PHP, a server side scripting language to create a connection with the database to form fields in the source code of the form.

    We can send the submissions to MySQL database using PHP by following the guide How-to-send-Submissions-to-Your-MySQL-Database-Using-PHP. Please see if this solution works for you and let us know for any further assistance that you need. We will be happy to assist you.

  • Profile Image
    KittySmack
    Answered on October 07, 2014 at 11:14 AM

    Thanks

    I am actually pretty good at PHP and MySQL, so this would be a great solution.

     

    Here is the URL

     

    https://secure.jotformpro.com/form/41571012313944

  • Profile Image
    Kiran
    Answered on October 07, 2014 at 02:01 PM

    It's great to know that you are good at programming with PHP and MySQL. The guide on sending-Submissions-to-Your-MySQL-Database-Using-PHP should help us in inserting or updating data in the database from the form. Also, this guide on How-to-Post-Submission-Data-to-Thank-You-Page should help in reading the form data so that we can send to the database. Please go through the guides and follow the steps that can help you in managing the data. 

    Please get back to us if you need further assistance. We will be happy to help.