What is JotForm?
JotForm is a free online form builder which helps you create online forms without writing a single line of code. No sign-up required.

At JotForm, we want to make sure that you’re getting the online form builder help that you need. Our friendly customer support team is available 24/7.

We believe that if one user has a question, there could be more users who may have the same question. This is why many of our support forum threads are public and available to be searched and viewed. If you’d like help immediately, feel free to search for a similar question, or submit your question or concern.


  • Profile Image

    Field value input via URL parameter from another form does not show in email

    Asked by bdoodle on November 23, 2015 at 01:13 PM

    Hi,

      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. 

    Please help.

    Thanks.

    another form email send post prepopulate
  • Profile Image
    JotForm Support

    Answered by jonathan 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

    https://form.jotform.com/53253981193965?whatOrdered={whatOrdered}&calculation={finalOrder}&firstName={firstName}&lastName={lastName}&emailAddress={emailAddress}&phoneNumber={phoneNumber} 

    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.

  • Profile Image

    Answered by bdoodle 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.  

  • Profile Image
    JotForm Support

    Answered by Kevin_G on November 23, 2015 at 06:51 PM

    Hi,

    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 : 

    https://form.jotform.com/53267382017960

    it will redirect to this : 

    https://form.jotform.com/53266659730968

     

    Please, try doing it and let us know if it works.

    Regards.

  • Profile Image

    Answered by bdoodle 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. 

  • Profile Image
    JotForm Support

    Answered by mert on November 24, 2015 at 02:57 AM

    Hi there,

    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.

    Thanks.

  • Profile Image

    Answered by bdoodle 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.

  • Profile Image

    Answered by Carina 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.