Class Management project (should track student details and track monthly payments)
Budget: ₹600 – ₹1,500 INR
Need a Google Sheet based solution
1. Database is required to store all details of all students. Unique key will be phone number(might
change as well)
2. Admin login can access the whole database, should have option to create, modify and delete
any record.
3. Admin login should have filter options to filter data by Branch, Grade, Batch (these fields can be
finalised later)
4. There should have a form to register new students with fields like Name, address, phone no
etc(those can be finalised later). A new row with the details will be created in the database after
successful submission.
5. There needs to be an option to record student's monthly payment
in database. If should be registered against last month-year for which payment is pending for that student(for e.g. if last payment month column is Feb and year 2022,then it will
update the column with Mar and 2022 after successful payment)
6. After each payment, a pdf should be generated as Receipt and will be sent to the student via whatsapp.
7. After 15th of each month, if the student has not made monthly payment for that month, an automated
whatsapp message will be sent to their id as reminder.
1. Database is required to store all details of all students. Unique key will be phone number(might
change as well)
2. Admin login can access the whole database, should have option to create, modify and delete
any record.
3. Admin login should have filter options to filter data by Branch, Grade, Batch (these fields can be
finalised later)
4. There should have a form to register new students with fields like Name, address, phone no
etc(those can be finalised later). A new row with the details will be created in the database after
successful submission.
5. There needs to be an option to record student's monthly payment
in database. If should be registered against last month-year for which payment is pending for that student(for e.g. if last payment month column is Feb and year 2022,then it will
update the column with Mar and 2022 after successful payment)
6. After each payment, a pdf should be generated as Receipt and will be sent to the student via whatsapp.
7. After 15th of each month, if the student has not made monthly payment for that month, an automated
whatsapp message will be sent to their id as reminder.