- bdoodleAsked on November 23, 2015 at 01:13 PM
I have created one PayPal Payment form (https://www.jotform.com//?formID=53253981193965) that all my order forms will eventually invoke via a Thank You Page URL. I'm having the following problem during testing...
While all field values I pass from the order (e.g. https://www.jotform.com//?formID=53184737463967 on http://www.madsails.com/Order_FS_sailsTest.html ) properly appear on my PayPal Payment form, the numeric field values do NOT appear in the emails I send (either notifier or autoresponder) from this form after it's submitted. I notice that the numeric fields are zeroed out on the PayPal Payment form immediately after submission. I'm guessing this relates to my problem.
NOTE: The sample order form above invokes my PayPal Payment form when its Payment Method field is set to PayPal or Credit/Debit card.
I need the original order total (field name = calculation) to appear on emails in addition to the actual amount paid which does appear in the last field.
- JotForm SupportjonathanAnswered on November 23, 2015 at 03:02 PM
If my understanding of the process is correct, what you were trying to do is pre-populate the 2nd form http://www.jotformpro.com/form/53253981193965 with data from the 1st form http://www.jotformpro.com/form/53184737463967 using the Custom Thank You URL redirect method.
This was the Thank You URL I see on the 1st form
When you submit the 1st form, were you able to actually see the 2nd form gets pre-populated with the data?
If its not and the field (Order Total field) is empty, then the Email will be empty also.
I also noticed that Send Post Data method is Enabled on the 1st form.
I think this is causing the conflict on the prepopulating of data via the URL parameter of the form TY page. So I suggest you disable the Send Post Data option on the form.
Hope this help. Let us know how it goes.
- bdoodleAnswered on November 23, 2015 at 03:22 PM
I am able to see the proper population of the fields on the 2nd, Payment Form with values passed on the Thank You Page URL from the first form.
I disabled the Send Post Data option on both the forms, but it still doesn't work.
I don't see the value in the Order Total field in the emails from the 2nd form.
- JotForm SupportKevin_GAnswered on November 23, 2015 at 06:51 PM
After making some test I found a way to solve your issue, to populate a calculation field, first you need to pass the value to a text field, add a text field to your second form and receive there the amount from the first field :
Now, in the Order Total field, the calculation field, open the wizard and add the Order Total Received :
You should do this always, when you want to catch a value from other form, since if you only pass it to the calculation field it won't work.
Here are my sample forms, you can clone both if you want :
it will redirect to this :
Please, try doing it and let us know if it works.
- bdoodleAnswered on November 23, 2015 at 10:15 PM
Thanks for your response.
The problem is not that I don't receive the order total passed from the Order form. That works fine. I see all the passed values on the PayPal Payment form, and the calculation field, Order Total, is used to populate the Payment Amount and PayPal payment fields at the bottom. (My payment goes through PayPal fine as well.)
The problem is only that the value in the Order Total on the PayPal Payment form does not appear in the notifier email that is sent at form submission. When I included the Payment Amount field in the email earlier, the value in that field was also missing. Right after I click the button to go to PayPal, the Order Total field is zeroed out along with the PayPal amount. I can see it before I'm redirected to the PayPal screen. This must happen before the email is generated, but I don't know why.
Calculation field values DO appear on emails generated from non-PayPal forms.
Having said that, I added a hidden non-calculation field to receive the order total on my PayPal Payment form and the value does appear in the email. That solves my immediate problem, but does not explain why all calculation and PayPal field amounts are being zeroed out when I submit my PayPal Payment form. Is creating a duplicate field the only solution?
It is unfortunate that we have to create duplicate non-calculation fields so often. I also have to do it when copying the Purchase Order total elsewhere for further manipulation on my Order form.
- JotForm UI DevelopermertAnswered on November 24, 2015 at 02:57 AM
First of all, on behalf of my colleagues, you are kindly welcome. Unfortunately, creating a non-calculation field is the only way to transfer values from one form to another, then you can give that field's value to "calculation" field.
Generally, "calculation" fields are designed to take values from the current form's fields not from another form, I assume that's why the transferred values return "0" when you try to do that. However, you are right. Adding a extra hidden field makes your form crowd and complicated without a reason; but it does no harm to your form.
On the other hand, transferring values from one form to another could be more simple than current one. Your consciousness-expanding feedback gives us an idea about future versions of this feature. You can be sure that it will be taken into consideration.
For further assistance, please don't hesitate to contact us.
- bdoodleAnswered on November 24, 2015 at 04:54 AM
For the sake of the other readers of your forum, let me repeat:
My transfer of a field value to a calculation field on a second form via a parameter on a Thank You page URL worked fine.
I can also include a calculation field in form email and that generally works fine.
The problem I was having only occurred on my PayPal form. A value was received from my order form by my PayPal form and loaded into a calculation field. This was accomplished via a parameter on the URL specified in the Thank You page on my order form. This field was then used to populate a second calculation field. My PayPal order specified the use of the second calculation field to send to PayPal. This all worked fine and PayPal transactions worked fine.
Immediately after I hit the Submit to PayPal button, however, both the calculation fields were zeroed out and the field values did not show up on the email generated by my PayPal form upon completion. I don't know whether this always happens to calculation fields on PayPal forms or only on mine due to something I did.
To get around my problem, I created a new non-calculation field in my PayPal form and passed the order total to it instead of my original calculation field. I then populated the original calculation field from my new field and substituted the new field for the calculation field on the email. The new field was not zeroed out after PayPal form submission as the calculation fields were, and its value appeared properly in my email.
The problem with calculation fields that was the subject of this thread was only WITH EMAIL and it only happened on my PayPal form. (As a side note, I have observed that you also cannot reliably pass the total from a Purchase Order payment tool directly to a calculation field on the same form. It must first go into a non-calculation field.)
I hope the above information helps others.
- CarinaAnswered on November 24, 2015 at 06:20 AM
Thank you for the additional clarification. I will make further tests regarding the instability of calculation and will forward it to our developers.
If you need further assistance please let us know.