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

    Prepopulate form from another form

    Asked by cheekyface on November 10, 2015 at 04:37 AM

    Hi.

    I'm trying to follow the instructions to pre-populate a booking form (http://www.jotform.com//?formID=52277689537977) with the data from a quote form (http://www.jotform.com//?formID=52278015605957).

    I'm unsure what tags to use when mapping the Date and Time value fields (Day, Month, Year + hrs & mins and am/pm).


    The string of URL that I have (using the prepopulate app linked above) is as follows (I'm only showing the section for the time fields): 

    startend[hourSelect]=1&startend[minuteSelect]=15&startend[ampm]=AM&startend[hourSelectRange]=1&startend[minuteSelectRange]=15&startend[ampmRange]=AM&dateOf[month]=11&dateOf[day]=10&dateOf[year]=2015

     

     

    The data from the Time field on the quote form is as follows:

    ID: #input_86_hourSelect, #input_86_minuteSelect, #input_86_ampm, #input_86_hourSelectRange, #input_86_minuteSelectRange, , #input_86_ampmRange
    Name: {start86}

     

     

     

    The data for the date field on the quote form is as follows:

    ID: #day_141, #month_141, #year_141, #lite_mode_141
    Name: {eventDate}

     

    Am I correct to assume that I would simply add the section relevant as per this example:


    startend[hourSelect]={start86#input_hourSelect}&startend[minuteSelect]={start86#input_86_minuteSelect}&startend[ampm]={start86#input_86_ampm}&startend[hourSelectRange]={start86#input_86_hourSelectRange}&startend[minuteSelectRange]={start86#input_86_minuteSelectRange, ,}&startend[ampmRange]={start86#input_86_ampmRange}&dateOf[month]={eventDate#month_141}&dateOf[day]={eventDate#day_141}&dateOf[year]={eventDate#year_141}

     

    The yellow highlighted area is also confusing.  Do I use the blank space between the commas??

    eg. #input_86_minuteSelectRange, ,

     

    Hope to hear from you soon.

    Cheers,

    Danny

  • Profile Image

    Answered by cheekyface on November 10, 2015 at 05:04 AM

    So far doesn't seem to be working.

    Here's my URL.  Maybe I didn't follow instructions correctly??


    http://form.jotformpro.com/form/52277689537977?yourFirst={yourFirst}&yourEmail={yourEmail}&addedInfo14={addedInfo14}&yourSurname={yourSurname}&addressOf={addressOf}&ageFrom={ageFrom}&ageUp={ageUp}&howMany={howMany}&haveYou85=Yes&startend[hourSelect]={start86#input_hourSelect}&startend[minuteSelect]={start86#input_86_minuteSelect}&startend[ampm]={start86#input_86_ampm}&startend[hourSelectRange]={start86#input_86_hourSelectRange}&startend[minuteSelectRange]={start86#input_86_minuteSelectRange, ,}&startend[ampmRange]={start86#input_86_ampmRange}&dateOf[month]={eventDate#month_141}&dateOf[day]={eventDate#day_141}&dateOf[year]={eventDate#year_141}&howLong={howLong101}&titleOf={titleOf113}&venueName={venueName}&howLong105={howLong102}&nameOf={yourFirst}%20{yourSurname}&whoDo={company}&suburb={suburbOr}&locationeg={suburbOr}&companyName138={company}&moreThan={additionalDates157}

  • Profile Image
    JotForm Support

    Answered by Chriistian on November 10, 2015 at 05:47 AM

    Hi,

     

    Can you try to use this URL instead?

    http://form.jotformpro.com/form/52277689537977?yourFirst={yourFirst}&yourEmail={yourEmail}&addedInfo14={addedInfo14}&yourSurname={yourSurname}&addressOf={addressOf}&ageFrom={ageFrom}&ageUp={ageUp}&howMany={howMany}&haveYou85=Yes&startend[hourSelect]={start86:hourSelect}&startend[minuteSelect]={start86:minuteSelect}&startend[ampm]={start86:ampm}&startend[hourSelectRange]={start86:hourSelectRange}&startend[minuteSelectRange]={start86:minuteSelectRange}&startend[ampmRange]={start86:ampmRange}&dateOf[month]={eventDate:month}&dateOf[day]={eventDate:day}&dateOf[year]={eventDate:year}&howLong={howLong101}&titleOf={titleOf113}&venueName={venueName}&howLong105={howLong102}&nameOf={yourFirst}%20{yourSurname}&whoDo={company}&suburb={suburbOr}&locationeg={suburbOr}&companyName138={company}&moreThan={additionalDates157}

     

    I have used this {fieldname:fieldproperty} to get the value from the form (i.e {eventDate:year}).

    startend[hourSelect]={start86:hourSelect}&startend[minuteSelect]={start86:minuteSelect}&startend[ampm]={start86:ampm}&startend[hourSelectRange]={start86:hourSelectRange}&startend[minuteSelectRange]={start86:minuteSelectRange}&startend[ampmRange]={start86:ampmRange}&dateOf[month]={eventDate:month}&dateOf[day]={eventDate:day}&dateOf[year]={eventDate:year}

     

    Do let us know if you need further assistance.
    Regards.

  • Profile Image

    Answered by cheekyface on November 10, 2015 at 06:46 AM

    Ok thanks.

    Just to be sure I'm doing this correct, should it work if I simply enter the URL in the browser and go to it?  If so then there must be a problem.  Even with your URL it's only recalling data entered from a previous entry that I made (perhaps the last one on the booking form before I created this URL and about a month old).

    Also what I'm trying to do is to send the booking form link to the user who completed the quote form.  That way they receive the quote auto-responder with the link to the booking form included as a text link (or image link).

    If it works correctly then I assume that the booking form will open in a new window when they click on it and all the common fields that are mapped between the quote and booking forms, will be pre-populated?

    I don't want to have to use a the 'redirect thank you page option' so if there is a way I can make it work with email notifications that's my preference.

    Cheers,
    Danny.

  • Profile Image
    JotForm Support

    Answered by Chriistian on November 10, 2015 at 08:35 AM

    Hi Danny,

     

    The URL will not work if you directly use it. As the data used in the URL provided are still variables that need to be changed to the actual data from your form. You can add the URL as text link to your form's auto responder if you want instead of adding it on the thank you page. 

     

    Do let us know if you need further assistance.
    Regards.