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

    Auto Calculating Dates w/Conditions

    Asked by RogerYelvington01 on October 23, 2014 at 12:34 AM

                                      

    1 Year

    1 Year PIF

    Free Month

    Join Date:

    10/20/2014

    10/20/2014

    10/20/2014

    First Draft:

    11/20/2014

    11/20/2015

    11/20/2014

    Expiration:

    11/20/2015

    11/20/2015

    12/20/2014

    Enhancement:

    04/15/2015

    04/15/2016

    04/15/2015

    Term:

    12 months

    12 Months

    13 Months

     

     

     

     

     

    2 Year

    2 Year PIF

    Free Month

    Join Date:

    10/20/2014

    10/20/2014

    10/20/2014

    First Draft:

    11/20/2014

    11/20/2016

    11/20/2014

    Expiration:

    11/20/2016

    11/20/2016

    12/20/2016

    Enhancement:

    04/15/2015

    04/15/2016

    04/15/2015

    Term:

    24 months

    24 Months

    25 Months

     

     

     

     

     

    M2M

     

     

    Join Date:

    10/20/2014

     

     

    First Draft:

    11/20/2014

     

     

    Enhancement:

    04/15/2015

     

     

    Term:

    Open End

     

     

     

     

     

     



    Page URL:
    http://www.jotformpro.com/form/42916390730960

    table draft 1 year
  • Profile Image

    Answered by RogerYelvington01 on October 23, 2014 at 12:39 AM

    I want to be able to create auto calculations, based off of the following examples in the table:

     

    1 Year Contract

    1 Year Contact Paid in Full

    2 Year Contract

    2 Year Contract Paid in Full

    M2M (month to month contract)

    ----------------------

     "Free Month" will add one month to the expiration

     

    I've tried to do it in the attached form, but I'm having the issues working through the conditional logic to get it to play in an actual use case scenario.  And ideas or suggestions would be helpful, thank you!

     

     

  • Profile Image
    JotForm Support

    Answered by jonathan on October 23, 2014 at 08:07 AM

    Hi,

    I need to ask more details to understand the actual requirements you need.

    I checked  your jotform http://www.jotformpro.com/form/42916390730960.

    Can you describe what needs to be calculated? 

    Was it suppose to be number of days/months/year between 2 dates?

    You can calculate date difference similar to this form template http://www.jotform.com/form-templates/calculate-number-of-days

     

    If Days can be counted, then its possible to determine months(30 days) or years(365 days).

    After getting the auto calculated number of Days.. you can then use the number to calculate amount/price.

    Hope this help. Please inform us if  you need further assistance.

    Thanks.