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.
Hotel Reservation: How to Count Room Numbers with Respect to Their Types?Asked by Kgr0up on January 24, 2016 at 09:21 PM
I am working on booking form of upt to 8 rooms and each room can choose from different fares of 4 different hotels.
I am uisng the inventory widget to check availability of the 4 hotels, but haven´t stablished a way to limit too when choosing within each room.
I thought I could make a calculation where it would count for example if any of the rooms (1 to 8) had fares from A to F (hotel 1) and that total send it to the invenory widget and show a message if there was no availability and the samme for each hotel , but have´t figure out how to use the count formula, could you help me out of the formula or any suggestions on any other way to solve this?
I have tried the count formula on the last field on the form, counting only the first room if any of the A to B fares is chosen, but it is not workink, and I would still need to count rooms 2 to 8 ...
As far as I understand from your question, you want to enhance the inventory widgets functionality and combine the room availabilities with room types as well. With additional "Inventory" Widget you can achieve similar scenario. For each room type create one "Inventory" Widget, then split the total available room number for every one of them. For instance, you have 60 rooms "Fairmont Mayakoba", set 60 free for it like you have already done, then set 30 for "Fairmont Double" room, 20 for "Fairmont Single" room and 10 for "Fairmont Deluxe"; but the total free room number has no relation with the room types' availability, so you need to set them individually.
Your "Show/Hide a Field" condition should be like the following:
Also, I made a demo to demonstrate what I'm talking about. Please, check it from the link below:
I hope this method will work for you. Please, don't hesitate to contact us, if you need any extra help.