- DavidGrayTVAsked on July 23, 2017 at 02:19 PM
Hi guys, Can you please check and correct my form calculations for the age of the bride and groom. Irrespective of the year that is entered the same age result of 47 years old always occurs.
- JotForm SupportKiranAnswered on July 23, 2017 at 03:24 PM
I have checked your JotForm and see that the calculation is done based on two date field. However, the date of birth is being collected on a different field.
Since the Brides date of birth field is not sending the field data to the Date of Birth, it is not displaying the correct value. You may setup a new condition on the form to copy the Brides date of birth field data to Date of birth as shown below:
This should calculate the date difference correctly. You may setup similar condition to the Groom fields as well.
Hope this information helps! Please get back to us if you need any further assistance. We will be happy to help.
- DavidGrayTVAnswered on July 25, 2017 at 03:12 PM
I did exactly as you described above but the response is still the same :(:(:( I did reply via the email with an attachment but nobody ever gets back and seeing as there is no attachment upload feature here I will not hold my breath for a quick efficient response as it has already been two days now.
- JotForm SupportMike_GAnswered on July 25, 2017 at 03:54 PM
In order for me to check the issue that is happening in your form, I have created a clone version of it in my account. The issue you are having can be fixed by following the steps below.
From the builder page of your form, click the condition icon of the "Brides date of birth" (Birth Date Picker widget).
The conditions associated with the field will show. Edit the condition that copies value of that field to the "Date of birth" field.
Change the condition's action from "Copy a field's value" to "Calculate a field's value".
Upon changing the option, notice that the "Brides date of birth" icon in the calculation area is set to "A-Z". Please update that by clicking the icon to "0-9" to indicate a numeric value that will be used for the calculation. — Conditional-Logic-Inserts-Text-Calculation-Into-A-Field
Save the condition and test your form after.
If you have other questions or concerns, please feel free to contact us again anytime.
- DavidGrayTVAnswered on July 25, 2017 at 03:57 PM
Seeing as though you have already done the hard work can you please just do it for me please I'll buy you a drink
- JotForm SupportMike_GAnswered on July 25, 2017 at 04:15 PM
As you have requested, I have made the changes to the conditions associated with the "Brides date of birth" and "Grooms date of birth" fields in your form.
Please check your form and let us know if you have other questions or concerns.
Absolutely orgasmic. Thank you so much it works just fabulously. You are a star.