I will do attendance tracking with google form

V
v_vaibhav
V
v_vaibhav
Vibhanshu
do attendance tracking with google form
Full Screen
do attendance tracking with google form
Full Screen
Full Screen
do attendance tracking with google formdo attendance tracking with google formdo attendance tracking with google form

About this gig

I have developed a Check-In/Check-Out system using Google Forms and Google Sheets. When an employee submits a Check-In, the entry is recorded in the CheckData tab. If the employee later submits a Check-Out, the system locates the corresponding check-in row and updates it with the check-out time along with the calculated duration of their session.

Additionally, I've created an automated reporting feature. You can navigate to the Report tab, then click the custom menu at the top and select "Generate Report". This will generate a report based on the data from the CheckData tab, summarising attendance durations in a structured format.

  • Tool

    • Google sheets

Get to know Vibhanshu

Vibhanshu

Senior Google App script Developer

  • FromIndia
  • Member sinceSep 2021

  • Languages

    Hindi, English
I bring over 4 years of hands-on experience in using Google Apps Script to streamline and automate business operations. Proficient in creating custom dashboards within Google Sheets to visualize and manage complex datasets efficiently. Successfully automated a wide range of tasks in Google Sheets, significantly reducing manual effort and error. Developed and deployed dynamic Google Forms and Google Slides programmatically, ensuring seamless user interaction and reporting. Experienced in handling Management Information System (MIS) tasks, including automated reporting and real-time data upd

My Portfolio

Related tags