What is JotForm?
JotForm is a free online form builder which helps you create online forms without writing a single line of code. No sign-up required.

At JotForm, we want to make sure that you’re getting the online form builder help that you need. Our friendly customer support team is available 24/7.

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.

  • Profile Image

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

    Asked by KittySmack 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
    JotForm Support

    Answered by Kiran 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

    Answered by KittySmack on October 07, 2014 at 11:14 AM


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


    Here is the URL



  • Profile Image
    JotForm Support

    Answered by Kiran 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.