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

    Integration with another system

    Asked by DedersSP on November 14, 2013 at 07:40 AM

    Hello, 

     

    I need to integrate JotForm with other system which is not available on integration list, is there any possibility to chat with you about it? 

     

    I need to have some PHP field integrated with another database, I think some INNERJOIN would solve my trouble, let's talk about it?

     

    Thank you very much JotTeam,

     

    Best Regards

     

    JotForm chat integrate integrated
  • Profile Image

    Answered by jedcadorna on November 14, 2013 at 08:58 AM

    We can forward a request to our developer team but we cannot give you any timeframe on when or if it will be implemented. That will still depends on their priorities. May we know what integration are you proposing so that our developer will have an idea if this is feasible. Please provide as much detail so that it will be easier for them to review the request. Thanks and God bless.

  • Profile Image

    Answered by DedersSP on November 14, 2013 at 01:34 PM

    Understood, 

     

    I'd like to have a form which sends post data to another, 

     

    For example:

     

    Form 1: Fields @NAME, @LASTNAME are sent to the DataBase, a new row is stored.

     

    Form2: Show these fields stored from Form1 @NAME, @LASTNAME in a DROPDOWN on Form2.

     

    That would be really nice, I may help them to understand it better. How clear was I? Let me know.

     

    Thank you very much JotTeam

  • Profile Image
    JotForm Support

    Answered by EltonCris on November 14, 2013 at 02:44 PM

    Hi there,

    We have a workaround for that, there's a tutorial about passing form submissions to an external database. Here's a guide: How to Insert/Update Submissions to Your MySQL Database Using PHP. Since requires basic PHP knowledge since the process requires PHP scripting.

    Regarding on populating form data from form1 to form2, that's already possible with Jotform. Here's how:

    1. Copy the field tags in your 1st form. These tags must be the fields that you'd like to pass to the 2nd form.

    To get field tags, right click the field, select "Show Properties" then copy it in the properties window.

    2. Use this app to pre-populate data to your second form. http://prepopulate.jotform.io/. Just browse your 2nd form, fill in sample values and generate the URL. Copy the URL and paste it to notepad. Replace the sample values you filled in to that form with the field tags you copied from the first step.

    Example:

    https://www.jotform.com/form/1234567890123?name1={name}&email21={email}

    3. Lastly, set that URL as your first form custom thank you URL.

    Test your form afterwards. It should pass the values from your first form to your 2nd form after form submission.

    If you require further assistance, feel free to let us know here.

  • Profile Image

    Answered by DedersSP on November 26, 2013 at 10:11 AM

    Ok, understood! I've just arrived from some holiday and I'll do it! 

     

    For sure, I'll let you know the whole process!

     

    Thank you very much

  • Profile Image

    Answered by milbra on May 09, 2014 at 10:22 PM

    Could you explain part of the code in the Thank You Page Wizard?  Are "name1" and "email21" the "Name" listed in Properties?  And are {name} and {email} the values to pass?