calculate amount of days

  • Profile Image
    purifica
    Asked on December 30, 2013 at 01:19 AM

    if i have an arrival date and a departure date, can i calculate the amount of days the person is staying?

  • Profile Image
    EltonCris
    Answered on December 30, 2013 at 05:17 AM

    Hi,

    Unfortunately, we do not have such tool but that's doable when use two DateTime (calendar) fields under Quick Tools then get your form source code and inject custom script that calculates the number of days.

    Example: https://shots.jotform.com/elton/workaround/calculate_calendar_fields.html

    If you require assistance to achieve this function, let us know your final form with the two calendar fields so we can assist you with this.

    Thanks!

  • Profile Image
    purifica
    Answered on December 30, 2013 at 06:01 AM

    yes please a bit of help would be great: 

    http://jotform.me/form/33622202173442

     

    Can the agenda report block all dates that are booked?

  • Profile Image
    EltonCris
    Answered on December 30, 2013 at 06:15 AM

    Thanks. I will get back to you with final form later today or tomorrow morning (GTM+8).

    I am not sure if I can provide you workaround for the booked dates, this sounds pretty complex but let me just give it a try.

    Thank you!

  • Profile Image
    purifica
    Answered on December 31, 2013 at 09:13 AM

    great, just let me know

  • Profile Image
    EltonCris
    Answered on January 02, 2014 at 02:16 AM

    @purifica

    Sorry for the delay, been hang up on new year celebration. :)

    Anyway, here's the date calculation script, just take your form source code and add the calculation script below your form source code.

    Calculation script: http://pastiebin.com/52c51021a2d88

    Demo: https://shots.jotform.com/elton/booking_calendar/date_from_to_calculation.html

    You can then embed your form using the entire source code on your page, or you can save it as HTML file and upload it to your server.

    I'm not sure if I can provide you a booking function, it seems very complex, and it may involved custom PHP script with Jotform API. I couldn't promise you anything about this but hopefully if I find extra time, I will give this a try.

    Let me know if you have issues with applying the calculation date script. Thanks!

  • Profile Image
    Vacademy
    Answered on January 02, 2014 at 02:24 AM

    wow!! amazing! 

    am really impressed with your customer service, an example to follow... 

    and if you do find time to try the booking thing, that would be great, just let me know, no hurry. 

    oh.. same form is here, just two different users.. sorry for the confusion.

  • Profile Image
    EltonCris
    Answered on January 02, 2014 at 06:01 AM

    You're welcome!

    Feel free to let us know should you need further assistance.

    Cheers!

  • Profile Image
    EltonCris
    Answered on January 02, 2014 at 06:07 AM

    Yes, I will get back to you with the booking thing if I have time. Give me at least a day or two. :)

  • Profile Image
    ParkingRetkinia
    Answered on February 08, 2014 at 04:18 PM

    Hi

     

    I have got the same problem, but i need have the return value of the number of days in
    the text box so that the wizard will create rules discovering the price of parking for a given quantity does not. I'm not so great knowledge to do it. Can someone help me?

    My form number http://polski.jotform.com/jsform/40376156246354

  • Profile Image
    jonathan
    Answered on February 08, 2014 at 08:30 PM

    @ParkingRetkinia

    Hi, please create a new separate topic/thread regarding your problem. Use this link to do this

    http://www.jotform.com/contact/ . Provide as much details as you can.

    We will attend to your post as soon as we can.

    Thanks.

  • Profile Image
    mariarus
    Answered on February 20, 2014 at 10:03 AM

    Hi Elton,

    I would like to use the form you have done:https://shots.jotform.com/elton/workaround/calculate_calendar_fields.html

    Where can I achieve the script?

    Thanks!

    María

  • Profile Image
    EliezerN
    Answered on February 20, 2014 at 11:28 AM

    @María

    I found in a Elton's previous message the link of the page where my he shared his script, here it is: http://pastiebin.com/52c51021a2d88

    However, I am not quitely sure if it needs to be a customized script for your form specifically or if it could be the same. At any rate, if that does not work for you, kindly open a new thread and make your request so that we can provide help for your particular form.

    You can open a new thread here: http://www.jotform.com/answers/answer.php

    Thanks