Implement a submit and display student grades scenario


Tutorials - Tutorials

User Rating: / 0
Implement a submit and display student grades scenario

In this article we will explain the implementation of a scenario in which a teacher will fill out a form with student grades, and each student will only need to log in to view his grade on the website, in a menu item. Here's how it's done:

Download the sample form

Form fields

The grade submission form's structure needs to contain the following fields:

  • student: a dropdown which will be filled in, using a custom script, with all available user accounts
  • grade: a textbox in which the teacher will type in the student's grade
  • submit: a submit button through which the form will be submitted

Custom code

As mentioned above, a part of the functionality is implemented through the use of a custom script:

  • Head to Components >> RSForm!Pro >> Manage Forms >> edit your form >> Components >> edit the student field and add the following code in its Items area:

  //<code> $items = array(); // Prepare the empty array $db = JFactory::getDbo(); // Prepare the database connection // Keep this if you'd like a "Please select" option, otherwise comment or remove it $items[] = "|Please Select[c]"; // Run the SQL query and store it in $results $db->setQuery("SELECT name, id FROM #__users"); $results = $db->loadObjectList(); // Now, we need to convert the results into a readable RSForm! Pro format. // The Items field will accept values in this format: // value-to-be-stored|value-to-be-shown // Eg. m|M-sized T-shirt foreach ($results as $result) { $value = $result->id; $label = $result->name; $items[] = $value.'|'.$label; } // Multiple values are separated by new lines, so we need to do this now $items = implode("\n", $items); return $items; //</code>  

Database mappings

RSForm!Pro includes a Database mappings feature which allows us to save submitted data in any database table of our choosing. We will use this feature to replace the user id associated with the submission (which currently is, by default, completed with the submitter's id - the teacher's user id in our case) with the student's user id. We will explain the logic behind this a little later on.

Head to Components >> RSForm!Pro >> Manage Forms >> edit your form >> Properties >> Mappings and create a database mapping as follows:

  • click on New Query
  • set the Connection type - choose Local if the database table is located on the same server as the website, Remote otherwise
  • set the Method field to Update
  • click on Connect to database
  • Select the _rsform_submissions table in the Database table field
  • add {student:value} in the UserId field
  • Scroll down to the WHERE area and add {global:submissionid} in the SubmissionId field.

Frontend menu item

We will use an instance of the View Submissions menu item to allow the student to view their grades.

After creating the menu item, edit it and, in the Options area, apply the following:

  • select your form in the Form dropdown
  • set Enable Viewing Submissions ? to Yes
  • Add the code below in the Row Layout area:

  <tr><td>{details}Your grade is: {/details}</td><td>{grade:value}</td><td>{detailspdf}Download PDF{/detailspdf}</td></tr>  

  • Add the code below in the Details Layout area:

  <table width="100%"><tr><td>Grade: </td><td>{grade:value}</td></tr></table>  

  • set Show submissions for user ID to login

By setting up the View Submissions menu item in this manner, all the students need to do in order to view their grades is to log in to the website and access it. This is possible because we have replaced the submitter's id (which should have been the teacher's user id) with the student's id, so the component will display the submission associated with the student.

  • Please note that RSForm!Pro exports do not include database mappings. You will need to create the mapping explained above even if you restore the sample form in your installation.
  • The same goes for the View Submissions menu item, you need to create it manually after importing the form.

About Us

Royal Developer Top three Web Designing and Web Development Company in Dehradun, Uttarakhand, India. Royal Developer Best SEO Company in Dehradun takes pride in its philosophy of 'Employee First' which empowers to create a real value for the customers. Royal Developer can offer Best and cheap Website Development Software Development & SEO Services. We are the Best service Provider of SEO, SEM, SMO ServicesCompany in Uttarakhand. Web Designing Course in Dehradun, Web Designing Classes in Dehradun, Web Design Training Institute in Dehradun, Web designing institute in dehradun, Best institute for web designing in dehradun, Web development training in dehradun, Web development course in dehradun, Web Designing Training in Dehradun.


- Contact Information - 

Add : RDIT Services Pvt Ltd, 3rd Floor, RGM Plaza, Above Chandu Canteen,
          23 Chakrata Road, Dehradun - 248001, Uttarakhand, India

Email : 


 : +91 8171200108, +91 8979462451,
                                  +91 7895753921

Quick Enquiry Form

Enter your full name

Enter your valid email address

Enter your correct mobile number

Invalid Input

Your Message
Invalid Input

Enter Code
Enter Code
  RefreshInvalid Input


You are here: Home Tutorials Implement a submit and display student grades scenario