- sthakerAsked on March 14, 2015 at 11:20 AM
I have a hidden field that totals up some charges based on user input. That total is then supposed to get passed to a PayPal field. The hidden total field updates correctly, but that value does not always get passed to the PayPal field. For example, if a user is supposed to be charges $30 + $25 = $55, the hidden total field will show $55, but the PayPal field only gets $30. This does not happen for all submissions and just started this morning. I had made no other changes.
I have moved the hidden total field lower on the form, in the hope that the calculation would get made after everything else and go through properly.
Could you please assist?
- JotForm SupportjonathanAnswered on March 14, 2015 at 04:48 PM
I found some flaws in the calculation conditions you have setup on the form http://www.jotform.us/form/50713878184160
It is a bit complicated explaining them because it requires multiple modification. But to highlight main of them, this one can caused a reset to zero(0) value to the Friends members renewal even if it previously have positive value.
It is better also if you just assign a calculation value to each added Child so that it will be easy to total/calculate them since they are numeric value
I created a test form http://form.jotformpro.com/form/50725799939981? . Please test it and check if you can find issue with the calculation.
Let me know if you find issue on the calculation similar to what you had.
If you need to, you can also clone my test form so that you can review it on your Form Builder.
user guide: -How-to-Clone-an-Existing-Form-from-a-URL
If you find the form applicable for your use, you can update it after cloning.
I made temporary changes that you need to update if you want to use it.
1. Make some fields *Required field as needed
2. Re-enable the disabled conditions in the Form Conditions.
3. Double check if the Email and Paypal settings are using your own.
- sthakerAnswered on March 14, 2015 at 08:27 PM
Thanks for the reply. The form you created gets close but I need the total to depend on multiple conditions. I'm trying to create this logic in the form, is that possible?
If "was membership renewed" equals "Yes" OR "Not sure" then set soccer fees to 0
If "was membership renewed" equals "No" AND number of children equals 1 then set soccer fees to 20
If "was membership renewed" equals "No" AND number of children is greater than 1 then set soccer fees to 25
- BenAnswered on March 15, 2015 at 12:24 AM
I would still do as suggested by my colleagues about the calculation values and I see that you have set them 010 so that no option is the only one with a value.
Now looking on what you wrote above I have added 2 conditions that should match the above and a new field called _soccer fees.
It is a hidden field right above the Soccer fees form calculation and we add to it 20 or 25 or leave the default value of 0 and hide it.
This way we have a field where we can pass the value and then have it picked up by the form calculation before it is passing it off to the PayPal.
It should work as you wanted it to - but once I started I immediately removed the 3 conditions that were associated with the Soccer fees field or they would be conflicting with the new ones.
I would also like to suggest to never use conditions on the form calculation widget when you are inserting value since it will always try to do its own calculations. Instead in most cases it would be best to use another field that gets used by the form calculation itself.
This is the jotform that I have made the change above: http://form.jotformpro.com/form/50730981264961 Please do let us know if that works in the manner that you are looking for.