Prepopulate form from another form

  • cheekyface
    Asked on November 10, 2015 at 4: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

  • cheekyface
    Replied on November 10, 2015 at 5: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}

  • Chriistian Jotform Support
    Replied on November 10, 2015 at 5: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.

  • cheekyface
    Replied on November 10, 2015 at 6: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.

  • Chriistian Jotform Support
    Replied on November 10, 2015 at 8: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.