HR System Development with AppSheet

I'm seeking an experienced Google AppSheet developer to design an HR system integrated with Google Sheets. The system should include:

1. Attendance Tracking:
- A feature for clock-in and clock-out
- A function that cater special views based on roles, allowing specific individuals to view records of tardiness and early departures
- Capability to see absences and corresponding leave requests
- Automated emails for late arrivals and early departures
- Integration of leave requests, categorizing them accordingly
- Compact linkage of leaves and absences to monthly salary for automatic deductions

2. Experience:
- Freelancers must provide detailed descriptions of previous HR system projects done, specifically showcasing their AppSheet development skills and experience in Google Sheets integration.

3. Qualifications:
- The ideal freelancer should have experience in HR system development, proficiency in AppSheet and have a strong background in Google Sheets integration and databases.

Please include your portfolio showcasing relevant work done and your rates. This project is time-sensitive and needs to be completed within a week. Your proposal should be detailed and tailor-made for this project.