Today I focused on improving our project structure and enhancing session management functionality. My work spanned from migrating the system to a new Google Sheet to implementing a fully functional login session with new attributes.
One of my first tasks was migrating our existing data to a new, more organized Google Sheet. This migration ensured a more efficient data structure better suited for scalability. Alongside this migration, I integrated Google Apps Script into the project, automating key processes and streamlining operations. This integration allows for better handling of backend processes—data manipulation, trigger-based actions, and synchronization with external services—while maintaining a seamless user experience.
To improve maintainability and readability, I reorganized our project repository. I created clear directory structures, organized files by function, and added necessary documentation to help future developers understand and contribute to the project. This reorganization ensures both current and future team members can quickly find relevant code and resources, making collaboration more efficient and reducing error potential.
A significant improvement was implementing a fully functional login session. By introducing robust session management, users can now securely log in with their session maintained across different pages or interactions. This eliminates repeated logins, enhancing user experience while strengthening security through user activity tracking. The session is managed effectively using PropertiesService, ensuring secure and persistent login sessions.
To enhance our data structure, I introduced a new attribute and linked it across two separate sheets. This enriches our dataset by providing additional context and improving how data relates between sheets. By linking these attributes, I created a more efficient way to manage and reference data, ensuring updates in one sheet automatically reflect in the other. This change increases system flexibility and improves data integrity between related datasets.
I also attempted to implement functionality to fetch clock-in times based on user sessions. By associating clock-in times with active sessions, I aimed to automate time tracking, reduce manual data entry, and ensure accurate records. While still in progress, this feature will streamline user activity tracking and contribute to a more robust time-management system once fully implemented.