Building an interconnected 3 jotforms scenario

  • asimsidiqi
    Asked on January 13, 2015 at 7: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 :)

     

  • Mike
    Replied on January 13, 2015 at 9: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.

  • asimsidiqi
    Replied on January 14, 2015 at 7: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?

     

  • Jeanette JotForm Support
    Replied on January 14, 2015 at 11:01 AM

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

  • Mike
    Replied on January 14, 2015 at 6: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.