Need calculation help

  • Profile Image
    AZDBAdesze
    Asked on March 13, 2019 at 10:59 PM

    Hi 

     

    I am looking to calculate when a member joins a member the club. 

     

    Example: 

    If a user joins in the month of November and the the membership ends on May 31. I want to use a prorate feature that charges $10 per a month and adds 25 on the initial date of joining.

    I was advised to use this 

    https://www.jotform.com/help/268-How-to-Insert-Text-or-Calculation-into-a-Field-Using-Conditional-Logic

    I need your minds on this one. 

  • Profile Image
    jherwin
    Answered on March 13, 2019 at 11:25 PM

    Is the month has a dropdown option or it should be selected on datepicker? Please further explain your requirements so we can make a workaround and demo form for you.

    If the month is based on the date that the user chooses with datepicker then I'm afraid we need to calculate it by days to determine how many months is the membership.

    We'll wait for your response.

  • Profile Image
    AZDBAdesze
    Answered on March 20, 2019 at 05:12 PM

    The date is when the user opens the form and choose prorated 

    The end date is May 31. 

    Calculation is 

    If a person is looking to join in Nov then the calculation should be any amount per a month until May 31st. 


  • Profile Image
    jherwin
    Answered on March 20, 2019 at 06:54 PM

    I see. So the end date is fixed May 31st.

    Could you please check this demo form: https://form.jotform.com/90787314577974.

    I calculate the days between the current date and end date then divide it to 30 to get the number of months. I cannot find a function that gives the number of Days of a Month so you will need to either assume a fixed 30/31 days and calculate.

    Could you please explain the calculation (formula) to us?

  • Profile Image
    AZDBAdesze
    Answered on April 09, 2019 at 12:50 AM

    Ok I am trying something new with the calculations.  Still the same issue, but just a new way of calculating.  I am using the localized calendar and right now the dates I am picking to make sure the form is calculating properly. I am not getting the numbers below when I change the dates. I need help?


    https://form.jotform.com/90978502195163


    June  
    July  
    August  
    September 116
    October 106
    November 96
    December 86
    January 76
    February 66
    March 56
    April 46
    May 36
  • Profile Image
    Victoria_K
    Answered on April 09, 2019 at 03:34 AM

    Hello,

    Firstly, I would suggest to combine conditions using 'ALL' rule. Also, Date is not equal to any month particularly, please try checking if Date 'contains' every month value instead of 'is equal'. Here is a sample condition:

  • Profile Image
    Kiran
    Answered on April 09, 2019 at 10:03 AM

    @tim.nollan25,

    If you are experiencing any issue with your forms, we request you to open a new thread and provide us with the form ID/URL so that one of our support team members can assist you.

    Thanks!

  • Profile Image
    AZDBAdesze
    Answered on April 10, 2019 at 07:30 PM

    Victoria's answer did not work. 


    Still looking for help

  • Profile Image
    jherwin
    Answered on April 10, 2019 at 08:43 PM

    Give me more time to check this. I will update you via this thread.

  • Profile Image
    jherwin
    Answered on April 11, 2019 at 10:56 AM

    Sorry for delayed response. I checked the calculation and the months that did not work as expected is these:

    June  
    July  
    August  
    September
    October
    November

    Please check your calculation condition, those months did not show expected results because the calculation was incomplete.

  • Profile Image
    AZDBAdesze
    Answered on April 15, 2019 at 09:58 PM

    It works now.


    Now I want to use this form to feed to another form using only the localized date and total.


    In other words I don't want the months that are hiding to show on a report or google spreadsheet. I want it hidden.

  • Profile Image
    BDAVID
    Answered on April 15, 2019 at 10:59 PM

    Your new question will be addressed in the following thread: https://www.jotform.com/answers/1794102-