Integration with another system

  • Profile Image
    DedersSP
    Asked 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

     

  • Profile Image
    jedcadorna
    Answered 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
    DedersSP
    Answered 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
    EltonCris
    Answered 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
    DedersSP
    Answered 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
    milbra
    Answered 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?