🎯 Goal: To maintain a structured, easily filterable, and automation-friendly database of leads, tutors, classes, payments, and demo status.
We’ll create 5 interconnected tables (bases):
| Table Name | Purpose |
|---|---|
Parents |
All lead + class booking info |
Tutors |
Tutor pool with skill + availability mapping |
Demo Classes |
Track demo requests, status, and feedback |
Payments |
Razorpay sync for successful txns |
Class Schedules |
Finalized booked classes (paid) |
Parents| Field Name | Type | Notes |
|---|---|---|
| Parent Name | Text | Captured from Landbot |
| Mobile Number | Phone | Unique identifier |
| Child Grade/Class | Dropdown | 1–12 |
| Subject Needed | Dropdown | Math, Science, English, etc. |
| Tutor Preference | Linked Record | Connects to Tutors table (optional) |
| Demo Status | Single Select | Booked, Completed, Declined, Rescheduled |
| Demo Date | Date+Time | From scheduling block |
| Payment Status | Single Select | Pending / Paid / Failed |
| Razorpay Txn ID | Text | For reconciliation |
| Feedback Notes | Long text | If demo is completed |
Tutors| Field Name | Type | Notes |
|---|---|---|
| Tutor Name | Text | |
| Subjects | Multi-select | e.g., Math, Physics |
| Grades | Multi-select | Classes handled |
| Availability | Text or Time | e.g., Mon–Fri, 5–7PM |
| Hourly Rate | Number | Payout per hour |
| Assigned Students | Linked Record | Links to Parents table |
| Status | Single Select | Available / Assigned / Inactive |
Demo Classes| Field Name | Type | Notes |
|---|---|---|
| Parent Linked | Linked | Connects to Parents table |
| Tutor Linked | Linked | Assigned tutor |
| Demo Date/Time | Date+Time | Manually entered or from Zapier |
| Status | Select | Scheduled / Completed / Cancelled |
| Feedback Summary | Long Text | By tutor or parent |