Secure Checklist App Development
Budget: $250 – $750 SGD
I need a secure web application that lets Admin, Manager and Employee users complete and review daily checklists, attach evidence, and archive the results automatically. The stack should be React / Next.js on the front end, Node.js on the server side, with Supabase (PostgreSQL) handling auth and data.
User roles
- Admin
- Manager
- Employee
Every role must be able to:
- View checklists assigned to them
- Upload photos or documents directly to a linked Google Drive folder
- Generate a signed PDF summary of each completed checklist
Core requirements
• Role-based login with JWT or Supabase Auth and secure session handling.
• Exact-location GPS capture when a checklist is opened and when it is submitted; coordinates stored with the record.
• Google Drive API integration that streams uploads straight to Drive without touching local storage.
• Automatic PDF rendering of the finished checklist (logo, timestamp, location data) and a link back to the Google Drive file.
• Responsive UI built in Next.js with server-side rendering where it improves performance.
• PostgreSQL schema design for users, roles, checklists, and file references, managed through Supabase.
Acceptance criteria
1. A user on any modern browser can log in, see only the checklists meant for their role, and complete them without error.
2. Submitting a checklist stores form data, GPS coordinates with <10 m accuracy, and creates a PDF in less than five seconds.
3. The corresponding Drive folder shows the uploaded files instantly; the app stores only the file IDs.
4. Admin can pull a date-range report that lists every checklist with links to its PDF and Drive files.
Please keep the codebase clean, documented, and ready to hand off so I can extend the checklist templates later.
User roles
- Admin
- Manager
- Employee
Every role must be able to:
- View checklists assigned to them
- Upload photos or documents directly to a linked Google Drive folder
- Generate a signed PDF summary of each completed checklist
Core requirements
• Role-based login with JWT or Supabase Auth and secure session handling.
• Exact-location GPS capture when a checklist is opened and when it is submitted; coordinates stored with the record.
• Google Drive API integration that streams uploads straight to Drive without touching local storage.
• Automatic PDF rendering of the finished checklist (logo, timestamp, location data) and a link back to the Google Drive file.
• Responsive UI built in Next.js with server-side rendering where it improves performance.
• PostgreSQL schema design for users, roles, checklists, and file references, managed through Supabase.
Acceptance criteria
1. A user on any modern browser can log in, see only the checklists meant for their role, and complete them without error.
2. Submitting a checklist stores form data, GPS coordinates with <10 m accuracy, and creates a PDF in less than five seconds.
3. The corresponding Drive folder shows the uploaded files instantly; the app stores only the file IDs.
4. Admin can pull a date-range report that lists every checklist with links to its PDF and Drive files.
Please keep the codebase clean, documented, and ready to hand off so I can extend the checklist templates later.
Related categories:
PHP
NoSQL Couch & Mongo
Node.js
PostgreSQL
AngularJS
API
Next.js
Web Application