Case study
SJ Visitor
Visitor and student-pickup system for a school
A gate tablet app and admin console for S.J. Public School, Jaipur, that records every visitor, verifies student pickups and issues gate passes.

01Overview
A considered experience.
Built for real people.
Everyone who enters S.J. Public School is now on record. Security staff check visitors in on a tablet: phone OTP, identity, a live photo and the reason for the visit, whether that is a half-day pickup, a meeting with a teacher or the principal, an admission enquiry or a fee payment. The app issues a gate pass that can be printed or shared. Student pickups are verified by OTP or a parent pickup card, so a child only leaves with an authorised adult. The admin console shows live counters and an activity feed, and manages students, parents, cards, staff and devices, while teachers see only their own class.
Built at True Value Infosoft.
02Key features & capabilities
Printable and shareable gate passes
Student pickup verified by OTP or parent pickup card
Admin console with live counters, activity feed, reports and CSV export
Separate admin, security and teacher roles
03Tech stack
04Technical architecture
The technology behind the experience.
- Expo tablet app and React admin on one Supabase backend
- Row-level security on every table and an activity log written by triggers
- Private storage with signed URLs; photos compressed before upload
- Scheduled job that deletes old visitor photos automatically
05Explore the product

Let?s work together
Interested in working
together?
I?m open to new projects and collaborations.
Let?s build something great.