Prepopulating from one form to a different form

  • wmoreno2006
    Asked on June 19, 2018 at 11:14 AM

    Hello.

     

    I'm writing to ask for help with the following form: 

    https://form.jotform.com/81654766551162

     

    When question 50. is yes, it should pre-populate the first few fields. However, I can't get the first "state affiliate" to prepopulate. Can you help?

  • David JotForm Support Manager
    Replied on June 19, 2018 at 12:30 PM

    If you are looking to populate fields based on previous field selections, you can do it through conditions, please follow this guide: https://www.jotform.com/help/268-How-to-Insert-Text-or-Calculation-into-a-Field-Using-Conditional-Logic 

  • wmoreno2006
    Replied on June 19, 2018 at 1:55 PM

    Hi BDAVID. Did you see the condition that's already in the form?

  • luisvcsilva
    Replied on June 19, 2018 at 3:13 PM

    Hi, I noticed that the "stateAffiliate28" field is not being prepopulated in a new form as you intended, in order to achieve this you'll have to assign calculation values to each one of the strings in the dropdown menu of the field "stateAffiliate28" (I recommend that you use integers as calculation values), as shown by the images below:

    1529435014lg0 Screenshot 10

     

    1529435028lg1 Screenshot 21



    You can see the fixed form working here:

    1529435295GIFrecord 19 06 2018  150730 Screenshot 32

     

    This problem probably happened because, by default, the values associated with the dropdown menu are the strings itself, and some of them could have invalid characters according to the RFC 3986 that regulates URL encoding. When you put the curly brackets around the field identifier, Jotform simply copies the value associated with that field. This might have caused this issue.

     

    Feel free to contact us,

    Thanks.

  • wmoreno2006
    Replied on June 20, 2018 at 8:39 AM

    Thanks, guys.

    These are great solutions. However, they are too general and don't address my specific needs. 

    To replicate what I'm experiencing, complete the following steps:

    1. https://form.jotform.com/81654766551162

    2. Settings

    3. Conditions

    4. See Attachments 1-3

    5. Complete form in line 1. Select "Affiliate Staff" for the classification. Answer "submit another activity report" with Yes, then click Submit. Don't close the window.

    6. You'll see that the State Affiliate on page 1 is populated, as is State Affiliate on page 2. See attachments 4-6. So I'm assuming if the field name in my other form, is the same as in this form, the same fields should populate.

    7. Complete the form again, leaving Affiliate Staff selected. Answer the last question, submit another report, No. Then answer the popup question to provide feedback Yes. Click Submit. See attachment 7 for correct responses.

    8. When I'm redirected, to form https://form.jotform.com/81693481751161), I see an empty selection for classification. It should be populated with "Affiliate Staff". See attachment 8.

    9. When I click Next, the State Affiliate field is populated corrected, along with the other fields. See attachment 9.

    10. See attachment 10. The field name in the first form matches the same field name in the second form. See attachment 11.


    So, is it possible to use the field name to populate the State Affiliate field in the second form using the redirect URL in attachment 3?

    Thanks.


  • wmoreno2006
    Replied on June 20, 2018 at 8:44 AM

    attachment 1

    Prepopulating from one form to a different form Image 109

    attachment 2

    Prepopulating from one form to a different form Image 21attachment 3

    Prepopulating from one form to a different form Image 32attachment 4

    Prepopulating from one form to a different form Image 43attachment 5

    Prepopulating from one form to a different form Image 54attachment 6

    Prepopulating from one form to a different form Image 65attachment 7

    Prepopulating from one form to a different form Image 76attachment 8

    Prepopulating from one form to a different form Image 87attachment 9

    Prepopulating from one form to a different form Image 98attachment 10

    Prepopulating from one form to a different form Image 109attachment 11

    Prepopulating from one form to a different form Image 1110









  • wmoreno2006
    Replied on June 20, 2018 at 8:58 AM

    I hope these are easier to read.


    attachment 1

    Prepopulating from one form to a different form Image 109


    2

    Prepopulating from one form to a different form Image 21


    3

    Prepopulating from one form to a different form Image 32


    4

    Prepopulating from one form to a different form Image 43


    5

    Prepopulating from one form to a different form Image 54


    6

    Prepopulating from one form to a different form Image 65


    7

    Prepopulating from one form to a different form Image 76


    8

    Prepopulating from one form to a different form Image 87


    9

    Prepopulating from one form to a different form Image 98


    10

    Prepopulating from one form to a different form Image 109


    11

    Prepopulating from one form to a different form Image 1110

  • Nik_C
    Replied on June 20, 2018 at 10:35 AM

    The name of the radio buttons in your form: https://form.jotform.com/81693481751161 is not correct when using the prepopulating link (second time):

    1529505090Capture Screenshot 10

    The link in that condition, currently, is:

    https://form.jotform.com/81693481751161?class={class}&centerOr={centerOr}&stateAffiliate28={stateAffiliate28}&name[first]={name:first}&name[last]={name:last}&organization={organization}&email={email}

    But, the field name (yellow) is - pleaseSelect:

    1529505167Capture Screenshot 21

    So prepopulate URL for that form should be: 

    https://form.jotform.com/81693481751161?class={class}&centerOr={centerOr}&pleaseSelect={stateAffiliate28}&name[first]={name:first}&name[last]={name:last}&organization={organization}&email={email}

    Please try, that link should work for you.

    You can actually test: https://form.jotform.com/81693481751161?pleaseSelect=Affiliate%20Staff

    Let us know how it worked.

    Thank you!

  • wmoreno2006
    Replied on June 20, 2018 at 12:14 PM

    Thanks. The URL you shared actually made both the classification on page 1 and the state affiliate on page 2 not work. 

    I'm not sure I'm being clear. The pre-populate URL works on the first form with the rainbow background. The pre-populate works on the second form with the turquoise background, except for the classification radio button. It's the pre-populate on the radio button of the second form (turquoise background) that I'm trying to fix.

  • David JotForm Support Manager
    Replied on June 20, 2018 at 1:08 PM

    As a far as I understood, this is what you are doing:

    The data from this form: https://form.jotform.com/81654766551162 

    Fills the fields of the following form: http://www.jotform.us/form/81693481751161 

    All the prepopulation works, except for the following field:

    1529514075thisfield Screenshot 10

    I have inspected the URL: https://form.jotform.com/81693481751161?class={class}&centerOr={centerOr}&stateAffiliate28={stateAffiliate28}&name[first]={name:first}&name[last]={name:last}&organization={organization}&email={email}

    And, I don't see the parameters for that field, so you need to add this: pleaseSelect={pleaseSelect}

    So, this would be the URL: https://form.jotform.com/81693481751161?class={class}&centerOr={centerOr}&stateAffiliate28={stateAffiliate28}&name[first]={name:first}&name[last]={name:last}&organization={organization}&email={email}&pleaseSelect={pleaseSelect}

  • wmoreno2006
    Replied on June 20, 2018 at 2:09 PM

    We're on the same page with the issue that needs resolving. However, I've added pleaseSelect into the URL in the form with the rainbow background, and the prepopulation still doesn't work for the classification. It works when I fill out the classification in first page with Partner, but not with Affiliate Staff.

    Also, when I select that I have another feedback on the second form, it prepopulates the first question. 

    This is weird. Thanks for your continued help.

  • aubreybourke
    Replied on June 20, 2018 at 3:26 PM

    OK, I found the issue. The parameter values being passed are case sensitive.

    1529522694uoaso Screenshot 10

    1529522711uk4eu Screenshot 21

  • wmoreno2006
    Replied on June 21, 2018 at 7:15 AM

    aubreybourke, that fixed the problem. Thank you!


    Drinks on me the next time you guys are in DC.