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

    Building an interconnected 3 jotforms scenario

    Asked by asimsidiqi on January 13, 2015 at 07:49 AM

    Now again I have scenario where there are 3 forms and 1 database.

    Form A:

    from where student will schedule an appointment with the wellness counselors.

    Form fields would be:

    Name:
    Student ID:
    Appointment for:
    Select Counselor:
    and more.. 

    Once this form is submitted, student and counselor will receive an email, and counselor manually schedule their appointment via emails.

    Now, student appear as per the schedule and the counseling processed has happened. After that counselor will have a form (FORM B) where counselor can select the student name (which was populated from FORM A), the other details from FORM A will appear. below this auto-filled information, there will be 2 fields.
    Field 1 will ask "is student appeared for the session? YES or NO"

    if field 1 is yes then Field 2 will ask notes

    Fields:

    [ Student details from Form A]
    Is student appeared for the session: Yes or No (radio buttons)
    Notes:

    On click of submit button student will receive an email to fill the Form C

    Form C will be auto filled with student's name only and a text-area to give his/her feedback.

     

    I want you to provide support and help me at your earliest. As a premium member I want explore Jotform possibilities and extend my premium package for years :)

     

  • Profile Image
    JotForm Support

    Answered by Mike on January 13, 2015 at 09:42 AM

    Unfortunately, our form processing system does not come with the membership functionality. It means, that there is no built-in option to connect the forms between each other and a single database.

    We can create some custom prepopulation links to populate the forms, but this is different from the database fetching. Please take a look at the following guides to get the idea:

    Prepopulating fields to your JotForm via URL parameters

    How do I prepopulate fields in one form with text input from another form

    If the second method (prepopulation) might work in your case, we can try to provide you with some examples. Thank you.

  • Profile Image

    Answered by asimsidiqi on January 14, 2015 at 07:23 AM

    Hi Mike,

     

    I guess both options are for passing field names with URL parameters. and in the scenario I have given has the name input field in Form A only.

    I don't know if the 2nd option you provided would work or not. Can you provide example and be more specific?

     

  • Profile Image
    JotForm Support Manager

    Answered by Jeanette on January 14, 2015 at 11:01 AM

    I'll forward your inquiry to Mike, so he can provide with an example later on.

  • Profile Image
    JotForm Support

    Answered by Mike on January 14, 2015 at 06:21 PM

    Here is some more information about a possible scenario based on prepopulation.

    Once this form is submitted, student and counselor will receive an email, and counselor manually schedule their appointment via emails.

    Now, student appear as per the schedule and the counseling processed has happened. After that counselor will have a form (FORM B) where counselor can select the student name (which was populated from FORM A), the other details from FORM A will appear. 

    It is not possible to select the student name on FORM B, but we can add a prepopulation link to the email of FORM A in order to populate the text box with the student name and other details. So the counselor can access the specific prepopulation link from email autoresponder (sent by FORM A) to get the data filled on FORM B.

    On click of submit button student will receive an email to fill the Form C

    Form C will be auto filled with student's name only and a text-area to give his/her feedback.

    The same technique can be used here. We can populate the student name field if the student access the form by specif prepopulation link from email (sent by FORM B).

    Here is an example (from this thread) where the form is populating email to form 2:

    http://form.jotformeu.com/form/21106494481350

    Thank you.