Starter sample workflow

School Data Entry Portal

Staff use controlled forms for admissions, billing, payments, debtor follow-up, student records, staff, boarding, results, expenses and attendance. Linked dropdowns reduce typo errors and keep records consistent.

View Academic Dashboard View Admin Dashboard

Demo note: This portal now uses controlled dropdowns for Class, Term and Student ID. In a live client system, these reference lists would come from the master Google Sheet tabs.

Admissions Enquiry Form

Capture admission enquiries. When Stage is Admitted, the system assigns a Student ID.

Fee Payment Form

Select Class first; Student ID list will show only admitted students in that class.

ClassStudent ID

Only students admitted under the selected class will appear here.

Student NameGenderParent/GuardianPhoneTermExpected AmountAmount PaidPayment MethodReceipt NoNotes

Invoice / Fee Billing Form

Create the amount a student is expected to pay for a selected term. Class filters the Student ID list.

ClassStudent ID

Only admitted students in the selected class appear here.

Student NameTermFee CategoryExpected AmountDiscount / ScholarshipDue DateBilling StatusNotes

Parent Follow-up / Debtor Action Form

Track calls, WhatsApp messages, promises to pay and escalation for fee recovery.

ClassStudent ID

Select a student to auto-fill parent details.

Student NameParent/GuardianPhoneOutstanding AmountFollow-up DateContact MethodPromise-to-pay DateOwnerStatusParent Response / Notes

Staff Record Form

Capture teacher and non-teaching staff records for operations and payroll planning.

Boarding / Hostel Record Form

Assign boarding students to hostel, dormitory and bed space.

ClassStudent ID

Only admitted students in the selected class can be assigned to hostel records.

Student NameHostel / HouseRoom / DormitoryBed SpaceBoarding StatusEmergency ContactMedical Note

Academic Result / Assessment Form

Record subject scores by term. Student ID is filtered by selected class.

TermClassStudent ID

Select class first to avoid entering scores under the wrong student.

Student NameSubjectCA ScoreExam ScoreTeacherRemarks

Expense Form

Record school expenses for management review.

Attendance Form

Record class attendance summary using controlled class and term lists.

Student Record Form

Select Class first; then choose an admitted Student ID from that class. Linked fields auto-fill.

ClassStudent ID

This prevents staff from choosing the wrong student or mistyping Student IDs.

Student NameGenderSectionParent/GuardianPhoneStatusNotes