Building on the automation provided by the Code.gs file, the ui.html file is the user-friendly front-end that makes the entire system accessible. Crafted with Bootstrap, the UI offers a clean, responsive design that adapts seamlessly across devices. It presents a simple modal-based form where users can select senders and destinations, enter cargo details, and even add new information on the fly.
Key features include dynamic form fields, a built-in date picker for selecting the pickup date, and toggleable sections for creating new destinations or reroutes as needed. This intuitive interface minimizes manual entry errors and streamlines the document generation process, ultimately making everyday tasks much easier. Together with the backend logic, the ui.html file completes a practical, end-to-end solution that enhances efficiency and accuracy in generating transport documents—all through the integrated power of the Google Workspace ecosystem.
As a side note, this project was built to be "just sufficient" for our workload. It is by no means a one-size-fits-all, standard solution for every company. However, it has sparked an interest in exploring a future version where companies could register online, create, and manage their own document templates in a similar fashion.
The Code.gs file is a practical, ad-hoc solution I built at work to simplify my daily tasks. Using Google Apps Script, it connects data stored in Google Sheets with a preformatted Google Docs template to automatically generate transport documents in PDF format. This tool pulls in essential details—like sender, destination, and pickup location—and fills in the document, saving me from repetitive manual work.
By organizing the process into small, focused functions, the code remains clean and easy to understand. It handles everything from reading and updating spreadsheet data to dynamically creating and customizing the document. This project not only streamlined our document workflow but also improved accuracy and efficiency, reflecting my ability to create practical solutions using Google Workspace tools.
Building on the automation provided by the Code.gs file, the index.html file is the user-friendly front-end that makes the entire system accessible. Crafted with Bootstrap, the UI offers a clean, responsive design that adapts seamlessly across devices. It presents a simple modal-based form where users can select senders and destinations, enter cargo details, and even add new information on the fly.
Key features include dynamic form fields, a built-in date picker for selecting the pickup date, and toggleable sections for creating new destinations or reroutes as needed. This intuitive interface minimizes manual entry errors and streamlines the document generation process, ultimately making everyday tasks much easier. Together with the backend logic, the ui.html file completes a practical, end-to-end solution that enhances efficiency and accuracy in generating transport documents—all through the integrated power of the Google Workspace ecosystem.
As a side note, this project was built to be "just sufficient" for our workload. It is by no means a one-size-fits-all, standard solution for every company. However, it has sparked an interest in exploring a future version where companies could register online, create, and manage their own document templates in a similar fashion.