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.
counting days in-between high and low seasonAsked by aeroloop on March 21, 2016 at 08:10 AM
Probably pretty simple but I can not work it out, I would like to have days calculated giving separate results if they are in low or high season in the calendar, working fine if I just choose low season but can not get both result working if it is in-between the two season range. i.e. 2 days in low season and 3 days in high season giving a total of 5 days all together.
Thanks for your help
I'm sorry, I'm quite confused how your form actually works. I see there are conflicting setup you have.
In your "Low season rental days" and "High season rental days", you are using a form calculation widget and adding fields inside it:
However, those fields seems to have already been deleted.
In your "Total rental days", you also have this formula:
However, you also have conditions setup doing almost the same calculations or a different one:
Condition 1 in your list: Noticed that you are adding "Low season rental days" and "high season rental days" when any of the season rental days are filled out. Remember that you are also subtracting the "To" and "From" date in your "Total rental days" causing a conflict.
Please do check your conditions and the calculations you have setup in the form calculation widget to avoid conflicts. Let us know if you need more help on this.
Ok I will make it more simple so you can understand what I need, check https://form.jotform.me/60808736938469 all I try to do is to have day count result separated for the two periods if I choose a date between high and low period I should get results in the two boxes i.e. 2 days in high and 3 days in low, unfortunately it give no result if I chose date in-between. It is I guess because it will insert to-minus-from into the result which is the total time period how can I separate and fill the right result box. Thanks.To0-9-From0-9
I'm not sure if understood your request, I understand that you want to get the days between two dates, but you need to split this result in two different calculations based on two periods which are high and low.
I think this could be possible to achieve by using conditions as explained by Charlie above, however, I cloned the form you provided and I was unable to apply it, I'm not sure what are you using to take a date as high or low, could you please provide us a bit more about it?
Is it between some dates?
Is it after some date or before one, I have tested and I got negative results, to instead of get for example 2 days, I got -2 days, something that I think is not logical, but please with a bit more about what are you trying to achieve we should be able to help you.
That is correct, I try to separate te results between low or high period, as you can see I use conditions to separate the dates but I can not get separated result, it is either low or high but not different amount of days separated in "low" amount of days and "high". if I choose dates in low or high section I get the result correctly, if I chose two dates in-between the high and low I get no result. Still I believe that the problem is in the calculation that give a total result between to and from and that this result give the total amount of days. looking for a way to go around it so I can set the rental prices accordingly.
Calculation widget do not give me the possibility to choose selected dates in different time period.
It seems that only one criteria can be fulfilled in your conditions, which is why only one result is shown (either high or low). So for example if the date is 2016-08-1, and 2016-08-1 is after 2016-06-30, the condition for High will be fulfilled so the result will be shown. However, this does not fulfill the condition for Low because the date 2016-08-1 is not before 2016-07-01 and as such the result will not be displayed for low.
Allow me some time to investigate a possible solution to get both high and low result for in between dates. I will get back to you once I have done so.
A possible workaround I could suggest would be to add an in-between field that you can use to get the days for in-between high and low season.
Then add a calculate field condition to calculate the number of days between the high season and the low season.
Once the condition is fulfilled if the date is in-between high and low season, the in between field will be filled with the total number of days.
Here's a demo so you can see it in action: https://form.jotform.com/60811787552966
You can also clone it to your account by following this guide: How to Clone an Existing Form from a URL
Hope this helps. Do let us know if you need further assistance.
Thanks so much for you help,
But this is exactly what I do not need, in short all I need to get is price that will include a total rental cost and will include low season prices with high season prices in the total.
I will try a different approach to find a solution, in the meantime, do not hesitate to let me know if you have another suggestion to make this form work.
Thanks a lot again for your great work.
Actually, the solution which has provided by my colleague is very close to the thing you want. With the following conditions, it adds the days to the "high season rental days" or "low season rental days" with respect to the date selection.
For "high season rental days",
For "low season rental days",
After keeping those values, we can add one "Form Calculation" widget and set the following calculation to get the total price:
The "lowPrice" and the "highPrice" on the image are going to be the constants and they will be multiplied with the days from "high season rental days", "low season rental days". I hope this one will meet with your needs.
If you need any extra information, please do let us know.
There I find a way to make it work.
A bit of work, all you need is to add fix dates in-between low and high season, see on this image I call them fixhigh and fixhigh-H or fixlow/fixlow-L for low season to calculate dates before and after the two season dates.
Check the day count as you may need to add a day in the full high season period as the result is from/to without using fixlow or fixhigh dates, as it is a rental I need to count all days included in the result.
You can test this form here
Thank you all again for you help and work to help making this work.
I am glad to know that you were able to make the form work. If you have any other concerns, feel free to contact us again. Regards.