An open source database system
The Academic Request System is a web-based application designed for college academic offices. It streamlines the process of handling and managing various academic requests, such as transcript requests, grade reports, and more.
- User Authentication: Secure login system.
- Dynamic Forms: Customizable forms for different academic requests.
- Email Notifications: Automated emails for request updates.
- Data Management: Requests are processed and stored efficiently.
- Responsive Design: Compatible with various devices.
- Backend: Node.js, Express.js
- Frontend: EJS, JavaScript, CSS
- Database: Google Sheets
- Other Tools: Google APIs, Nodemailer
- Clone the repository.
- Install Node.js and npm.
- Run
npm installto install dependencies. - Set up Google API credentials and update the
credentials.jsonfile. - Start the server with
node index.js.
-
Run the System: Initial screen upon starting the application.
-
Login with Institute Credentials: Securely access the system using your institute credentials.
-
Select an Academic Request: Choose and search for the type of academic request you need.
-
Submit the Request: Fill out and submit the necessary forms for your request.
-
Receive the Request Token: A ticket is generated once the form is submitted.
-
Tracking the Request Status: Stay updated with email notifications and online status tracking.
-
Admin Login: Admins can log in to access comprehensive data and management tools.
-
View and Manage Database: Admins have full access to the academic member database.
-
Closing Requests: Process the requests by updating their status. Automated notifications are sent upon status changes.
-
Email Updates to Students: Students receive email updates on the status of their requests.
Contributions to the project are welcome. Please follow the standard GitHub pull request process.