Another productive day at Stafify, with a strong focus on finalizing the system’s flow, researching HR tools, and diving deeper into AppSheet’s database integration. Here’s what I accomplished today:
Completed Day 3 of the Training Guide
I started the day by going through Day 3 of the training guide, which provided more insights into Stafify’s platform and workflow. This step helped reinforce my understanding of the system’s management structure, administrative tools, and best practices for handling HR processes.
Refining the Flowchart with the Team
With our initial system concept in place, we collaborated as a team to refine the system flowchart. This step was essential in ensuring that our planned attendance management system follows a smooth and efficient process. We focused on:
- Optimizing the workflow for user check-in/check-out
- Improving data flow and automation
- Identifying potential bottlenecks and pain points
The refined flowchart will serve as the blueprint for development, providing a clear roadmap for the system’s functionality.
Researching HR Platforms: Sprout & People HR
Since our system will integrate HR functionalities, I conducted a comparative study of Sprout and People HR, two well-known HR management solutions. The research focused on:
- Their attendance tracking capabilities
- How they manage employee records
- Their integration potential with other platforms
- Identifying key features we can incorporate into our own system
This research will help us ensure that our system aligns with industry standards and meets the needs of HR professionals.
Learning How Google Sheets Works as a Database in AppSheet
One of today’s biggest takeaways was exploring Google Sheets as a database within AppSheet. Since AppSheet relies on spreadsheet-based data management, I focused on:
- How data is structured and connected
- Setting up tables, relations, and data validation
- Understanding data synchronization between AppSheet and Google Sheets
- Exploring automation possibilities for real-time updates
This hands-on experience helped me understand how AppSheet can be leveraged for efficient data storage and retrieval, making it a potential foundation for our system’s backend.