Student Records

Student Records Setup

One-time setup: connect to the same Google Sheet used by the Certificate Admin Panel — just add a new "Students" tab.

Step 1 — Add a "Students" tab
In your existing KIT Certificates Google Sheet, add a new sheet/tab named exactly Students. Add these headers in Row 1:
id name phone father fatherOcc address school course branch timing joinDate email photo totalFees balance fee1amt fee1date fee2amt fee2date fee3amt fee3date fee4amt fee4date fee5amt fee5date fee6amt fee6date fee7amt fee7date fee8amt fee8date fee9amt fee9date fee10amt fee10date notes addedOn

Step 2 — Update Apps Script
Open the same Apps Script project (Extensions → Apps Script) → replace the code with the version below (handles BOTH Certificates and Students sheets) → Re-deploy as Web App.

Step 3 — Paste your Script URL below (same URL as the Certificate Admin Panel)

Google Apps Script URL

📋 Updated Apps Script Code (handles Students + Certificates):

Already configured? Skip to login →

—

Total Students

—

Fees Fully Paid

—

Balance Due

—

Total Fees Collected (₹)

➕ Add Student

📋 All Students

🔍 Search

🎓 Add New Student

Fill in the student's details below. Saved instantly to Google Sheets — viewable and editable from "All Students".

✅Student added successfully!

❌Failed to save. Please try again.

Student Details

Student Name *

Phone Number *

Father's Name

Father's Occupation

Address

School / College

Course *

Branch

Batch Timing

Joining Date

Student Photo

Notes

💰 Fee Details

Total Course Fees (₹) *

Balance Amount (₹)

📅 Fee Payment History (up to 10 installments)

#	Amount Paid (₹)	Date Paid

📋 All Students (0)

	Name	Phone	Course	Branch	Total Fees	Balance	Status	Actions
⏳ Loading students…

🔍 Search Student

Search by name, phone number or course.

Student Records Setup

🎓 Add New Student

📋 All Students (0)

🔍 Search Student

Student Profile