How to forward approved submission through php and mysql?

  • Imran
    Asked on March 31, 2018 at 6:21 AM

    Dears,

    Hello I want to create simple website. in website 3 user have been working. one is student, second is teacher and third is principle. when the student is a holiday, he fill the application form and submit to teacher not directly submited to principle. then teacher is checked the application and forward to principle. plz tell me how teacher forward application thorugh php and mysql. i just do not know forward. Simply I just want to make a php form. plz help me. tell me smiple method code or refrence link plz help me.

     

     

    Thanks

     

  • Victoria_K
    Replied on March 31, 2018 at 9:12 AM

    Unfortunately, I am not sure if I understood your approval process. 

    Can you kindly clarify how the teacher is reviewing the submission? At submissions page? 

  • Imran
    Replied on April 7, 2018 at 11:37 PM

    ok tell you email address. i clarify to you via email. thanx.

  • Kiran Support Team Lead
    Replied on April 8, 2018 at 4:24 AM

    Please be noted that the guide that you are referencing is to send the form submission data to your MySQL database using PHP. If you want to notify the principal by the teacher for the submission of the student, please refer to the guide below:

    https://www.jotform.com/help/432-A-General-Approach-on-Building-an-Approval-Process-Workflow

    Let us know if that helps. If you are referring something different, please let us know. We will be happy to assist you further. 

  • Kiran Support Team Lead
    Replied on April 8, 2018 at 4:25 AM

    If you want us to send an email, you may send it to support@jotform.com so that one of our support team members can assist you.

    Thanks!

  • Imran
    Replied on April 8, 2018 at 11:56 PM

    you have said link.Its have been same working but some is different. In link 2 user have been working. customer A and mangerA. But in my website 3 user. 

    student: submit information.

    teacher : checked data. and forward to principle.

    prenciple: checked application and decide accept pr reject.

    my question is that how teacher data forward to prenciple through (forward button)?

    teacher click on forward button then data show to prenciple.

    student not directly submit application to prenciple.

    you see image and i hope you will be clarify.1523246181img Screenshot 10 

  • Scott JotForm Developer
    Replied on April 9, 2018 at 5:59 AM

    Hey Imran,

    As far as I understood, your diagram defines these three steps below:

    Step 1 - Student fills the form and Teacher gets a notification email

    Step 2 - If the teacher approves, s/he edits the form as approved and a notification email is sent to the Principle; if the teacher denies the application than an autoresponder is sent to Student

    Step 3 - Principle checks the form and upon approval or denial, an Autoresponder is sent to the Student.

    If so, you can still manage this situation via the user guide that was shared by my colleague Kiran on his answer.

    You just need to adjust the email conditions in regards to who is the reviewer (teacher or the principle) and the status.

    Here is a form that may explain it to you little better. Please clone the form to your account and then examine the email templates and the conditions. (You can clone a form using this guide)

    Example form: https://form.jotform.com/80982788323974

  • imran
    Replied on April 10, 2018 at 11:57 PM

    my email account "imranrafique688@gmail.com" plz contact to me. thanx.

  • Scott JotForm Developer
    Replied on April 11, 2018 at 4:25 AM

    Hey Imran,

    Please send us an email on support@jotform.com regarding your inquiry.

    You may also consult to the API team for a more detailed technical help at api@jotform.com

    Cheers.