pre-populate second form fields with the data of first form fields.

  • Profile Image
    realfoodsales
    Asked on July 27, 2017 at 03:38 AM

    Your example of populating form 2 with data from form 1 is EXACTLY what I need to do. although form 2 will have additional fields that need to be completed by another person.

    I have the 2 forms created already. Can I hire someone from Jotform to link them together?

    The form 1 submit will populate form 2 and send that form to another person who will complete it and send to me.



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

  • Profile Image
    ashwin_d
    Answered on July 27, 2017 at 05:42 AM

    Hello realfoodsales,

    We will try to help you achieve this. I did check your account and found that you have following three forms:

    CLIENT-New Product Intake form

    RFS-New Product Intake form

    Clone of Clone of SUPPLY MANAGEMENT

                                                    

    I am unable to understand your workflow. I would suggest you to please let us know which one is first form and which one is second form. You may also like to let us know which question from first form needs to be populated in which fields of second form. We will help you build form prepopulation URL.

    Please note that you can also yourself build your form's prepopulation URL by taking advantage of our "Field Prepopulator" app. 

    We will wait for your response.

    Thank you!

  • Profile Image
    realfoodsales
    Answered on July 27, 2017 at 12:43 PM
    Awesome thank you!!
    We are a new business introducing natural & organic food to foodservice operators. I am currently building a store for our website and I am happy to pay someone to do this form for me.
    If we can get this to work, I’ll need to upgrade to a paid account, because I hope to have many form submissions
    Form 1=CLIENT-New Product Intake
    Form 2=RFS-New Product Intake
    Every field in Form 1 is on Form 2.
    Form 2 has additional fields that need to be completed by someone else
    When Form 1 is submitted, Form 2 is sent to the person selected in the
    Real Food Sales Contact Field ( 1 person only from drop down list)
    bill@realfoodsales.com
    tina@realfoodsales.com
    robb@realfoodsales.com
    Form 2 is submitted to marketing@realfoodsales.com
    I have deleted Clone of Clone of SUPPLY MANAGEMENT . I was using the Field management tool to try to copy the clear form field without the submit button, but that didn’t also copy the necessary CSS. Anyway, that form is gone from my account.
    THANK YOU Again very much for your help,
    I hope it is clear what I need to have done, but feel free to call or email me with questions.
    Elle Ambrose
    970.259.5925
    ...
  • Profile Image
    ashwin_d
    Answered on July 27, 2017 at 02:30 PM

    Hello Elle,

    Thank you for your confirmation. We will try to help you achieve your requirement.

    We will get back to you on this soon.

    Thank you!

  • Profile Image
    realfoodsales
    Answered on August 01, 2017 at 11:43 AM
    Hi!
    Any progress yet on linking the two forms?
    Again, I am very happy to pay an additional fee for your help.
    Elle Ambrose
    I included earlier threads, below, as a reminder.
    ...
  • Profile Image
    ashwin_d
    Answered on August 01, 2017 at 01:06 PM

    Hello Elle,

    Please accept my apology for the delay. 

    I will complete your form and get back to you later today.

    Thank you!

  • Profile Image
    realfoodsales
    Answered on August 01, 2017 at 01:43 PM
    No worries…Thank you!!
    ...
  • Profile Image
    realfoodsales
    Answered on August 03, 2017 at 08:43 PM
    Hi,
    How’re things progressing with the form? We’re starting to have alot of need for it, so I’ll upgrade our account tomorrow.
    Thank you again for doing this.
    Elle Ambrose
    ...
  • Profile Image
    Kiran
    Answered on August 03, 2017 at 11:44 PM

    Currently, our colleague Ashwin is not online. However, he has received your message. Rest assured, you'll be posted with any update as soon as he has some information for you.

    Thank you for your patience and understanding. 

  • Profile Image
    realfoodsales
    Answered on August 04, 2017 at 12:43 AM
    Thank you for letting me know that I’m not forgotten :-)
    ...
  • Profile Image
    ashwin_d
    Answered on August 05, 2017 at 06:02 AM

    Hello Elle,

    Please accept my apology for the delay. Please use the following prepopulation URL in your first form's thank you message or notification email alert which will populate your second form with the input value of first form:

    https://www.jotform.us/72057979805167?contactName[first]={contactName:first}&contactName[last]={contactName:last}&companyName4={companyName4}&date[month]={date:month}&date[day]={date:day}&date[year]={date:year}&contactPhone[area]={contactPhone}&contactPhone[phone]={contactPhone}&contactEmail={contactEmail}&companyWebsite={companyWebsite}&product1={product1}&optionsp1={optionsp1}&checkAny13={checkAny13:0},{checkAny13:1},{checkAny13:2},{checkAny13:3},{checkAny13:4},{checkAny13:5},{checkAny13:6},{checkAny13:7},{checkAny13:8}&product2={product2}&checkAny={checkAny:0},{checkAny:1},{checkAny:2},{checkAny:3},{checkAny:4},{checkAny:5},{checkAny:6},{checkAny:7},{checkAny:8}&optionsp2={optionsp2}&sizesAvailablep1={sizesAvailablep1:0},{sizesAvailablep1:1}&sizesAvailablep2={sizesAvailablep2:0},{sizesAvailablep2:1}&product326={product326}&checkAny27={checkAny27:0},{checkAny27:1},{checkAny27:2},{checkAny27:3},{checkAny27:4},{checkAny27:5},{checkAny27:6},{checkAny27:7},{checkAny27:8}&sizesAvailablep3={sizesAvailablep3:0},{sizesAvailablep3:1}&optionsp3={optionsp3}&product4={product4}&checkAny32={checkAny32:0},{checkAny32:1},{checkAny32:2},{checkAny32:3},{checkAny32:4},{checkAny32:5},{checkAny32:6},{checkAny32:7},{checkAny32:8}&sizesAvailablep4={sizesAvailablep4:0},{sizesAvailablep4:1}&optionsp4={optionsp4}&product5={product5}&checkAny39={checkAny39:0},{checkAny39:1},{checkAny39:2},{checkAny39:3},{checkAny39:4},{checkAny39:5},{checkAny39:6},{checkAny39:7},{checkAny39:8}&sizesAvailablep5={sizesAvailablep5:0},{sizesAvailablep5:1}&optionsp5={optionsp5}&product6={product6}&checkAny44={checkAny44:0},{checkAny44:1},{checkAny44:2},{checkAny44:3},{checkAny44:4},{checkAny44:5},{checkAny44:6},{checkAny44:7},{checkAny44:8}&sizesAvailablep6={sizesAvailablep6:0},{sizesAvailablep6:1}&optionsp6={optionsp6}

     

    Hope this helps.

    Do try it out and get back to us if you have any questions.

    Thank you!

  • Profile Image
    realfoodsales
    Answered on August 05, 2017 at 02:43 PM
    Hi Ashwin,
    I’m sorry to be such a nuisance, but I have done something incorrectly, because when I submit the first form I get the response I pasted below (in purple color).
    And when I click on the link, I go to a form that has only the Company and Contact Names completed.
    Thank you for your hlep and your patience...
    _____________________________________________________________
    https://www.jotform.us/72057979805167?contactName[first]=Will&contactName[last]=Cooter&companyName4=Organic Bill&date[month]=08&date[day]=05&date[year]=2017&contactPhone[area]=(970) 456-7896&contactPhone[phone]=(970) 456-7896&contactEmail=test@name.com &companyWebsite&product1&optionsp1

    &checkAny13&product2&checkAny&optionsp2
    &sizesAvailablep1&sizesAvailablep2&product326&checkAny27&sizesAvailablep3&optionsp3&product4&checkAny32&sizesAvailablep4&optionsp4&product5&checkAny39&sizesAvailablep5&optionsp5&product6&checkAny44&sizesAvailablep6&optionsp6

    ...
  • Profile Image
    Jim_R
    Answered on August 05, 2017 at 04:08 PM

    Hey Elle - Looks like you're corresponding with us via email. Your message was cut off and the link is broken on your post. Can you open your thread instead and post your reply here? Just click the link below to open it:

    https://www.jotform.com/answers/1209624

    In case you're also attempting to send a screenshot, please do it directly on your thread and not via email.

    Related guide: How-to-Post-Screenshots-to-Our-Support-Forum 

  • Profile Image
    realfoodsales
    Answered on August 05, 2017 at 04:13 PM

    Hi Ashwin,

    I’m sorry to be such a nuisance, but I have done something incorrectly, because when I submit the first form I get the response I pasted below (in purple color).

     

    And when I click on the link, I go to a form that has only the Company and Contact Names completed, not the rest of Form 1 fields.

     

    Thank you for your help and your patience...

    _____________________________________________________________

     

    https://www.jotform.us/72057979805167?contactName[first]=Will&contactName[last]=Cooter&companyName4=OrganicBill&date[month]=08&date[day]=05&date[year]=2017&contactPhone[area]=(970) 456-7896&contactPhone[phone]=(970) 456-7896&contactEmail=test@name.com&companyWebsite=OG.com&product1=Test Product 1&optionsp1=flavor 1

    flavor 2

    flavor 3&checkAny13=Organic,Vegetarian,Plant based,,,,,,&product2=Test Product 2&checkAny=Vegetarian,Vegan,Plant based,,,,,,&optionsp2=flavor 1

    flavor 2&sizesAvailablep1=Bulk,Retail&sizesAvailablep2=Retail,&product326=&checkAny27=,,,,,,,,&sizesAvailablep3=,&optionsp3=&product4=&checkAny32=,,,,,,,,&sizesAvailablep4=,&optionsp4=&product5=&checkAny39=,,,,,,,,&sizesAvailablep5=,&optionsp5=&product6=&checkAny44=,,,,,,,,&sizesAvailablep6=,&optionsp6=

  • Profile Image
    ashwin_d
    Answered on August 05, 2017 at 05:43 PM

    Hello Elle,

    I have fixed the prepopulation URL which you have added in the notification email alert of first form. I have sent a test submission in your form and you must received an email with the clickable URL.

    Please click on the URL and see if it works as expected.

    Thank you!

  • Profile Image
    realfoodsales
    Answered on August 05, 2017 at 06:34 PM

    Ashwin, You are brilliant!  

    This was a complex project and it works perfectly now!

    Is there a way the First Form Submit Button can automatically send to whichever person is selected in the First Form Field "Real Food Sales Contact Person"?

    If I'm asking too much, just tell me...

    I have entered all of the emails in the drop down list of that field.

    I am so very impressed with JotForms customer service; I will tell all of my colleagues.

    Thank you!

    Elle

  • Profile Image
    EltonCris
    Answered on August 05, 2017 at 11:45 PM

    It is our pleasure to help you and we are happy that it worked perfectly now. :)

    We will answer your other question to a separate thread here https://www.jotform.com/answers/1216934. We'll be on this thread shortly.