Today I moved on to transferring the Workforce Records module to PHP. This module is essential because it allows HR personnel to view and manage employee attendance and record history.
The process began with setting up the UI and retrieving data from Google Sheets using PHP scripts. I created new functions to fetch data dynamically and render it in a structured, tabular format on the frontend. To keep things user-friendly, I included pagination and search features.
The biggest challenge was making sure the data mapping between PHP and Sheets was accurate. Since Sheets data comes in a raw format, it required additional parsing and indexing to convert it into something meaningful for our UI.
After a few iterations and tests, the module began to reflect real-time updates from Sheets, allowing us to confirm that the integration was working as expected. I also worked on cleaning up the data-fetching functions to ensure they didn’t make excessive API calls that could lead to throttling, as happened with AppScript.
With the groundwork laid, the module was now functional and ready for additional features and refinement in the coming days.