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

    I am having some major issues trying to get calculated fields to pre-po

    Asked by iiilucky1iii on March 09, 2016 at 09:23 PM

    I am having some major issues trying to get calculated fields to pre-populate. I have two forms; form #1 is a Purchase Order (https://form.jotform.com/60675198097166) this form will be filled out by my sales guys and then the salesman can click a switch field (on form #1) to "Request A Quality Control Inspection" upon turning the switch on, the form will trigger a condition to send out an email notification to said QC inspector with a Pre-Populated form "Form #2" (https://form.jotform.com/60676257886169) with the original Purchase Order information (hiding the costs, etc.) so that the QC inspector has the listed items to go and inspect.

    For whatever reason only my first item's information is pre-populating...not the remaining 5 items. Please help if you can...I know it is confusing how I explained it! :)

    -Amanda



    This is a re-post of a comment on How to Automatically Pass Form Data to Another Form

    JotForm email notification purchase pre-populated
  • Profile Image
    JotForm Support

    Answered by Charlie on March 10, 2016 at 01:59 AM

    I presume you are referring to the clickable link "Click Here to Complete The Inspection"?

     

    Here's the link anchored to it:

    https://form.jotform.com/60676257886169?orderDate[month]={orderDate:month}&orderDate[day]={orderDate:day}&orderDate[year]={orderDate:year}&estShip[month]={estShip:month}&estShip[day]={estShip:day}&estShip[year]={estShip:year}&salesman={salesman}&djfPo={djfPo}&vendorshipper={vendorshipper}&po={po}&notesFrom={notesFrom}&item1={item1}&item2={item2}&item3={item3}&item4={item4}&item5={item5}&item6={item6}

    I presume you want to populate the value from Form 1 to Form 2's "Item #1" that is a form calculation widget here:

    It seems like the prepopulate broke because you are using a "#" on the URL parameter.

    Here's one example:

    https://form.jotform.com/60691476218966?orderDate[month]=03&orderDate[day]=10&orderDate[year]=2016&estShip[month]=03&estShip[day]=10&estShip[year]=2016&salesman=Mike&djfPo=PO#0001&vendorshipper=test&po=123&notesFrom=&item1=1%20Arils%201%201%201%20%231&item2=1%20Arils%201%201%201%20UTIL&item3=%20%C2%A0%20%C2%A0%20%C2%A0&item4=%20%C2%A0%20%C2%A0%20&item5=%20%C2%A0%20%C2%A0%20&item6= 

    Noticed the blue hilghlight in PO#0001. What actually happens is that it appends it as part of the URL parameter and not as a form field value.

    Try not using a special character in your "Unique ID" widget and see if that works.

     

    I also see that your form calculation widget for "Item #1" in Form 2 has a formula in it. If you want to prepopulate it via URL, I presume it would be best to not have any value on it that might overwrite the prepopulated value. Or you can simply use a simple text box.

     

    Let us know if that works.