Integrating Google Form, Google Sheet and App Script for mini inventory management
Budget: $30 – $250 SGD
I am looking for a freelancer who can help me integrate Google Form, Google Sheet, and App Script to create a mini inventory management system. The system should have the following features:
- Inventory tracking: I need to be able to track if the personnel has borrowed and returned the tools/ parts.
- Email Alerts for error, and mismatch information: It would be great if the system can send me alerts when the someone did not return tooling in time, or any mismatch information.
Concept: Personnel scan through QR code of specific tooling for Google Form, after filling up, the form input will goes into google sheet for record and tracking purpose.
I don't require any specific reporting or data visualization tools integrated. Basic Google Sheets reports will be sufficient for my needs.
The system will be used by 10-20 users.
Ideal skills and experience for this job include:
- Proficiency in Google Forms, Google Sheets, and App Script
- Experience in creating inventory management systems
- Strong attention to detail and ability to ensure data accuracy
- Inventory tracking: I need to be able to track if the personnel has borrowed and returned the tools/ parts.
- Email Alerts for error, and mismatch information: It would be great if the system can send me alerts when the someone did not return tooling in time, or any mismatch information.
Concept: Personnel scan through QR code of specific tooling for Google Form, after filling up, the form input will goes into google sheet for record and tracking purpose.
I don't require any specific reporting or data visualization tools integrated. Basic Google Sheets reports will be sufficient for my needs.
The system will be used by 10-20 users.
Ideal skills and experience for this job include:
- Proficiency in Google Forms, Google Sheets, and App Script
- Experience in creating inventory management systems
- Strong attention to detail and ability to ensure data accuracy