-
AZDBAdeszeAsked 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
I need your minds on this one.
Page URL: https://form.jotform.com/73582015284153 -
jherwinReplied 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.
-
AZDBAdeszeReplied on March 20, 2019 at 5: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.
-
jherwinReplied on March 20, 2019 at 6: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?
-
AZDBAdeszeReplied on April 9, 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 -
Victoria_KReplied on April 9, 2019 at 3: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:
-
Kiran Support Team LeadReplied on April 9, 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!
-
AZDBAdeszeReplied on April 10, 2019 at 7:30 PM
Victoria's answer did not work.
Still looking for help
-
jherwinReplied on April 10, 2019 at 8:43 PM
Give me more time to check this. I will update you via this thread.
-
jherwinReplied 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
NovemberPlease check your calculation condition, those months did not show expected results because the calculation was incomplete.
-
AZDBAdeszeReplied on April 15, 2019 at 9: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.
-
David JotForm Support ManagerReplied on April 15, 2019 at 10:59 PM
Your new question will be addressed in the following thread: https://www.jotform.com/answers/1794102-