With a solid foundation from the past few days of research and planning, today marked an exciting step forward—we officially began development! The focus was on building the Login and Sign-up pages using AppSheet, Apps Script, and Google Sheets, along with implementing email verification.
Reviewed Day 4 of the Training Guide: Legal Compliance & Policies
The training for Day 4 focused on Legal and Compliance Policies and Programs, which are crucial for ensuring that our system adheres to company regulations and industry standards. Key areas covered included:
- Data privacy laws and how they impact user data handling
- Company policies on employee attendance and HR management
- Security measures for protecting sensitive information
- Compliance with labor regulations related to time tracking
Understanding these aspects helps ensure that our attendance management system aligns with legal requirements and best practices.
Developing the Login & Sign-Up Pages
We began the development process by working on the Login and Sign-up pages. Since AppSheet is a no-code/low-code platform, we focused on leveraging its built-in authentication features while integrating custom functionality. This involved:
- Setting up input fields for user registration and authentication
- Structuring the Google Sheets database to store user credentials securely
- Writing Apps Script functions to handle form submissions and user data processing
By using Google Sheets as our database, we ensured that the user information is stored in a structured and scalable manner.
Implementing Email Verification
To enhance security, we added an email verification feature, which ensures that only legitimate users can access the platform. The process involved:
- Generating verification codes upon user registration
- Sending emails automatically using Apps Script
- Creating a verification step in AppSheet to validate user input
This feature is crucial for improving data integrity and user authentication, making the login process more secure.
Linking Apps Script Code & Spreadsheet to AppSheet
A critical part of today’s development was integrating Apps Script with Google Sheets and AppSheet. This involved:
- Writing custom scripts to handle form validation and database updates
- Automating data syncing between Google Sheets and AppSheet
- Ensuring real-time updates so that any changes in the spreadsheet reflect instantly in the app
This integration allows us to leverage Google’s ecosystem while keeping the app dynamic and efficient.