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

    Submitting data to another form

    Asked by ownlabel on April 09, 2012 at 04:33 AM

    Hi, is it possible to pass the data from 3 fields from my form at http://www.ownlabelproduct.co.uk/downloads.html to my shopping cart crm which requires this...

    To get customers to sign up to your email list, use and modify the following code.

    <form action=http://www.romancart.com/prcontact.asp>
    <input type=hidden name=storeid value='12345678'>
    First Name: <input type=text name=firstname value=''><br>
    Email: <input type=text size=30 name=email value=''><br>
    <input type=hidden name=returnok value='http://URL TO GO TO AFTER SIGNUP'>
    <input type=hidden name=returnfail value='http://URL TO GO TO IF THERE IS A PROBLEM'>
    <input type=hidden name=returnexists value='http://URL TO GO TO IF THE PROSPECT IS ALREADY A CONTACT'>
    <input type=submit value='Sign up Now'>
    </form>

    Thanks

    Page URL:
    http://www.ownlabelproduct.co.uk/downloads.html

    another form email problem size name
  • Profile Image
    JotForm Support

    Answered by jonathan on April 09, 2012 at 05:18 AM

    Hi,

    I am not sure if your shopping cart crm also have JotForm form(I thought the post title say so)..
    But you may want to check this post Passing information via URL , it may give you idea on your inquiry.

    Please inform us if you need further assistance. Thanks.

  • Profile Image
    JotForm Support

    Answered by liyam on April 09, 2012 at 05:46 AM

    This is possible.  If you are going to use a thank you URL, you can get the POST submission data by activating that option on your form so it can be forwarded to your custom URL Thank-You page.  Here's how to post the data to your custom Thank you URL.

    Next, make sure that the next form's fields are allowed to receive variables so that the fields are prepopulated already.  Otherwise, I believe you'll have to use URL parameters (link provided by Jonathan above) to have it pre-filled.

    Please let us know if you need further assistance.

    Thanks.

  • Profile Image

    Answered by ownlabel on April 09, 2012 at 10:56 AM

    Hi, the shopping cart crm does not use JotForm.

    I am totally lost and cant get this to work.
    Please can you add in the script for me or instruct.

    The new php file is at http://www.ownlabelproduct.co.uk/test.php
    My JotForm is at http://www.ownlabelproduct.co.uk/downloads.html
    The Thank You page for JotForm is http://www.ownlabelproduct.co.uk/confirm.html
    The form I need to post to and then have it submit the info is at http://www.ownlabelproduct.co.uk/crmprospect.html

    How do I change the field names on JotForm to match the field names on my form at http://www.ownlabelproduct.co.uk/crmprospect.html which adds the customer details to my cart crm or is this not necessary?

    Thanks

  • Profile Image
    JotForm Support

    Answered by liyam on April 09, 2012 at 11:28 AM

    Hello,

    Can you confirm that these are the steps on how the form goes:

    1. Fill up Jotform form
    2. Redirect to the thank you page after submit
    3. Redirect to the next form

    Or is i:

    1. Fill up JotForm
    2. Redirect to next form after submit
    3. Go to thank you page

    Changing the field names in jotform to match your field names in your other form won't be necessary.  We can assign a variable for it later on.

  • Profile Image

    Answered by ownlabel on April 09, 2012 at 11:40 AM

    Hi, I dont need Jotform to go to the form at http://www.ownlabelproduct.co.uk/crmprospect.html 

    What I need is the following:

    1) Customer fills in the fields on my Jotform at http://www.ownlabelproduct.co.uk/downloads.html

    2) JotForm emailes me all the fields data from this Jotform as normal

    3) JotForm sends the data from the fields firstname, lastname & email to my shopping cart crm - the action is post to http://www.romancart.com/prcontact.asp 

    Hope it makes sense.

  • Profile Image

    Answered by jeanettebmz on April 09, 2012 at 01:14 PM

    As for your question, you may dump data submitted in forms created with Jotform onto your ASP page  by taking advantage of an option in our Form Builder to send those data using POST method.

    First, you need to enable send post data on your form:

    1.  Go to Setup & Embed
    2.  Click on Preferences button
    3.  Click Advanced Settings tab in the Preferences window
    4.  Select "Yes" in Send Post Data field

    5.  Click Close Settings then save your form

    Then you need to set your custom ASP page as the Thank You URL of the form. Click the link below to learn more about that:

    How to Redirect to a Page After Form Submission

    Let me tell you that you can customize which fields you need on your post data. Hope this helps you to accomplish what you are looking for

    Jeanette

  • Profile Image
    JotForm Support

    Answered by liyam on April 09, 2012 at 01:41 PM

    Thanks for the response.

    I just noticed that you are running ASP.  Is your site capable of running PHP as well?  I'm worried that I'm going to be giving instructions using PHP.  Anyhow, here are the variables to be received by your form:

    firstname
    lastname6
    email16

    Now, on your crmprospect.html file, copy this:

    1. On your body tag, copy the onload attribute and its values: 

    <BODY BGCOLOR="#FFFFFF" TEXT="#000000" LINK="#FF0000" VLINK="#800000" ALINK="#FF00FF" BACKGROUND="?" onLoad="javascript:document.yourformname.submit()">

    2. On your fields, add your variable in the value attribute. example:

    First Name: <input type=text name=firstname value='<% your asp firstname variable here %>'>
    Last Name: <input type=text name=lastname value='<% your asp lastname6 variable here %>'>
    Email: <input type=text size=30 name=email value='<% your asp email16 variable here %>'>

    This will prepopulate the form after submission.  The onload attribute in the form will actually auto-submit your form.  Try this out first if it works.

  • Profile Image

    Answered by ownlabel on April 09, 2012 at 03:00 PM

    Thanks for your hel so far.

    Ok, I created a clone copy of my form which is now at http://www.ownlabelproduct.co.uk/jotformtest.html and followed the instructions by jeanettebmz.

    Now when the customer clicks submit, they are taken to the page http://www.ownlabelproduct.co.uk/crmprospect.html but the 3 fields are not populated.
    As I understand it, this page now needs to submit the 3 populated fileds to my cart crm  automatically.

    I have tried to implement Liyam's info but the form is not being populated at http://www.ownlabelproduct.co.uk/crmprospect.html 
    Please can you look at the html source and tell me what is wrong.

    Thanks

     

     

  • Profile Image
    JotForm Support

    Answered by liyam on April 09, 2012 at 03:37 PM

    for the crmprospect.html, can you convert it to a .asp file so it will become crmprospect.asp?  Have your form also redirect the URL to this ASP page.

    After renaming the file, change the values to the following:

         First name textbox value: <% =Request.form ("firstname") %>

         Last name textbox value: <% =Request.form ("lastname6") %>

         E-mail textbox value:  <% =Request.form ("email16") %>

    Please try that if it will prepopulate with the submitted post data values.

  • Profile Image

    Answered by ownlabel on April 09, 2012 at 04:02 PM

    Ok, changed the page to an asp page.
    Changed Jotform to go to http://www.ownlabelproduct.co.uk/crmprospect.asp on submit

    Changed the values as above but still not populating (pleasee see http://www.ownlabelproduct.co.uk/crmprospect.asp if it is correct).

    The problem now is that even when I fill in the fields manually at http://www.ownlabelproduct.co.uk/crmprospect.asp and submit, the data is not added to the cart crm.

    What next?

    Thanks

  • Profile Image
    JotForm Support

    Answered by Mike_T on April 09, 2012 at 06:38 PM

    1. Liyam's code is right for ASP pages, but it is currently not included into your

    <form>. Please move the code to the <form> section. 

    2. It seems that your http://www.ownlabelproduct.co.uk/crmprospect.asp page is acting like a simple HTML page, but not as an ASP page. Your server will have to support some dynamic programing language to handle the POST data. Can you please contact your hosting provider to see if you can use PHP/ASP on your http://www.ownlabelproduct.co.uk/ site?

    Thank you for cooperation.

  • Profile Image

    Answered by ownlabel on April 10, 2012 at 02:04 PM

    The host provider states that they do support PHP.

    However, I have changed websites to see if other servers make a difference but still get errors.

    The new host supports PHP but not ASP as run Linex.
    The new test form is at http://www.healthcareltd.co.uk/jotformtest.html (cant use .asp)
    The new php file is at http://www.healthcareltd.co.uk/test.php

    The problem is that the JotForm at http://www.healthcareltd.co.uk/jotformtest.html is not passing the fields data and populating the form at http://www.healthcareltd.co.uk/crmprospect.asp

    This form is also not auto-submitting the details.

    ## best if we keep working on the form at http://www.ownlabelproduct.co.uk/jotformtest.html 

  • Profile Image
    JotForm Support

    Answered by Mike_T on April 10, 2012 at 05:38 PM

    Okay, so we can use PHP to sort this out. When I tried to make a test submission to http://www.romancart.com/prcontact.asp I have received the following message:

    This cart needs to be upgraded to use this feature.

    Is this supposed to work in that way? Please also confirm that mentioned action file can accept the following text inputs:

    firstname

    lastname

    email

  • Profile Image

    Answered by ownlabel on April 10, 2012 at 06:12 PM

    Hi Mike.

    I presume you are receiving the upgrade message as you are not stating a specific cart number as in my form at http://www.ownlabelproduct.co.uk/crmprospect.asp ie cart 37422 (see page source).

    Yes, those are the 3 fields to be used.

    These are the instructions from romancart.com

    --------- To get customers to sign up to your email list, use and modify the following code.

    <form action=http://www.romancart.com/prcontact.asp>
    <input type=hidden name=storeid value='37422'>
    First Name: <input type=text name=firstname value=''><br>
    Last Name: <input type=text name=lasttname value=''><br>
    Email: <input type=text size=30 name=email value=''><br>
    <input type=hidden name=returnok value='http://URL TO GO TO AFTER SIGNUP'>
    <input type=hidden name=returnfail value='http://URL TO GO TO IF THERE IS A PROBLEM'>
    <input type=hidden name=returnexists value='http://URL TO GO TO IF THE PROSPECT IS ALREADY A CONTACT'>
    <input type=submit value='Sign up Now'>
    </form>

    If you already have a sign up page for your customers and want to use server side scripting to add the prospect then you can also post remote=Yes in which case the page will simply display OK if the customer is added as a prospect successfully. -------------

    Thanks

  • Profile Image
    JotForm Support

    Answered by fxr on April 10, 2012 at 06:40 PM

    I dont really know asp very well, but should be able to help if you are willing to pursue this using php. 

    The first thing we need to do is get a page on your webserver taking the data from your form and being able to display that data when the 'first' form is rendered.

    Is it possible to create a page http://www.romancart.com/prcontact.php on your webserver and point your form at that on submit?

    (I have one caveat form being entirely confident of supplying a solution for thist and that is its hard to know the exact limitations of your CRM)

  • Profile Image
    JotForm Support

    Answered by fxr on April 10, 2012 at 06:42 PM

    Whats the JotForm form you want to prepopulate and I will draw up a quick example of how I would see this working on a php enabled webserver.

  • Profile Image
    JotForm Support

    Answered by fxr on April 10, 2012 at 06:44 PM

    OK. I understand what you are trying to do know. 

    I will be back in a few minutes with a php solution. 

  • Profile Image
    JotForm Support

    Answered by fxr on April 10, 2012 at 07:00 PM

    Is this what you are trying to do? 

    I made a clone of your (JotForm) form here (its identical in every way, I only removed most of the required fields) 

    Please enter the firstname, lastname & email fields and see a php version of your http://www.ownlabelproduct.co.uk/crmprospect.asp form get prepopulated with those fields. 

    This is the changes (php) code I used -> http://pastie.org/3764976

    (I do hope I have understood what you are trying to do) 

    --

    You havent enabled sending of POST DATA on your form btw; you also need to redirect the form upon submittal (the thankyou page) to wherever you are hosting the secondary form.

  • Profile Image

    Answered by ownlabel on April 11, 2012 at 02:09 AM

    Hi fxr - great. This is exactly what I need, thanks.

    Now I need the form http://pastie.org/3764976 to automatically submit the data.

    I have set up a new test form at http://www.ownlabelproduct.co.uk/jotformtest.html and changed my 2nd form to http://www.ownlabelproduct.co.uk/crmprospect.php so they work like yours.

    When the crmprospect.php automatically submits, it will redirect to a Thank you page http://www.ownlabelproduct.co.uk/ok.html or Already a member page http://www.ownlabelproduct.co.uk/already-member.html .

    I await the final code.

  • Profile Image
    JotForm Support

    Answered by fxr on April 11, 2012 at 02:33 AM

    Can you change your body onload line to:

    <BODY BGCOLOR="#FFFFFF" TEXT="#000000" LINK="#FF0000" VLINK="#800000" ALINK="#FF00FF" BACKGROUND="?" onLoad="javascript:document.getElementById("myform").submit();">

    and give your form an id of 'myform':

    i.e 

    <form id="myform" action=http://www.romancart.com/prcontact.asp>

     

    Havent tested that, but it should work OK as far as getting the form to automatically submit on load; not sure what your prcontact.asp script does. 

  • Profile Image

    Answered by on April 11, 2012 at 03:17 AM

    I have changed as suggested but does not automatically submit.

  • Profile Image
    JotForm Support

    Answered by fxr on April 11, 2012 at 03:38 AM

    it doesnt seem to want to run the javascript off ONLOAD parameter on the body tag. (possibly because the form ID hasnt been defined yet?)

    Can you remove it and add the javascript below at the bottom, before the closing body tag?

    i.e

    <BODY BGCOLOR="#FFFFFF" TEXT="#000000" LINK="#FF0000" VLINK="#800000" ALINK="#FF00FF" BACKGROUND="?">

    --------

    <script type="text/javascript">

    window.onload = function () {

        document.getElementById("myform").submit();

    }

    </script>

  • Profile Image

    Answered by ownlabel on April 11, 2012 at 04:05 AM

    Hi.

    All works now. Thank you all very much for your extended help, especially fxr.

    Have a good day.

  • Profile Image

    Answered by khrisell on July 04, 2013 at 06:07 PM
    Greetings!

    We are happy to announce that we have released Jotform Webhooks,  this feature would replace Send Post Data + Custom URL Thank You Page workaround in order to help you transfer forms data to your own database using your own script codes.

    To know more about Jotform Webhooks, please click here.

     

    Thank you for using JotForm. :)