Transform Time Tracking using your Phone: Automated Clock In/Out System with Google Sheets & Forms!
HTML-код
- Опубликовано: 15 фев 2023
- Get ready to be blown away by the power of automation! In just 15 minutes, I'm going to show you how to build a clock in and clock out system that will completely change the way you track time.
Imagine never having to manually enter data again or keep track of time with pen and paper. With this system, you'll be able to retrieve all the information you need with just a few taps on your phone and store it in Google Sheets for easy analysis and visualization.
And the best part? It's not just efficient, it's also super easy to use! Whether you're an administrator, manager, or just looking to streamline your time tracking process, this tutorial is perfect for you.
So, are you ready to take your time tracking to the next level and experience the magic of automation for yourself? Hit the play button and get ready to be amazed at how effortless and efficient this clock in and clock out system can be! And don't forget to check the pinned comment for the link to the same spreadsheet you'll see in the video so you can start practicing right away.
Let's do this!
Link for the spreadsheet!
docs.google.com/spreadsheets/d/1S-rb3wi6sI5sOxSgnO9zYLZAl_hEyAjdlfSZRPbuAgI/edit?usp=sharing
Thanks!
GREAT VERY USEFULL VIDEO
I really like what your demonstrating. Very good tutorial, but in the future please consider slowing down just a bit.
I am curious. If I have an employee table, for example, would there be any way to show which ones are currently clocked it and which ones out? So their current status? I am adapting the sheet for equipment actually and it would be great to have something like an inventory list where one can see which of the tools are available and which are in use. Thanks.
I want to keep my employees honest and use a time stamped GPS photo to clock-in clock-out. The idea is to pull the text for the time out of the photo and archive the photo.
Please help to make same type of thing but to calculate different vehicle exit and in timing and distance travel daily basis and Same on monthly bases
can we automate this to clock in and clock out using qr code?
If someone clock out accidentally with out click in, what will happen?
Can geofencing be used to stop employees clocking away from workplace.
Can you share the formulas please?
can we use location based on our phone?
very complicated for beginners like me.
Share the spreadsheet please!
Using the spreadsheet you provided how do you connect the forms output to the survey tab. When linking a form to a spreadsheet it creates a new first tab?
I have the same question
Is there a way to establish the location where the clock in/out is being made? Just to make sure the employees make the "punch in/out" while they are in the office?
I have the same question
password protected QR code, and swap it out regulary
@@jdcheejdchee Thanks!! So, if I understand correctly, you suggest we place a password protected QR in the office for them to scan and access the form. Is this right? Thanks again.
Started off good, but you begin to skip steps, like where did the survey come from? now i'm stuck
hi, Can I have the formula for WEEK column in Survey Tab. Thank you
Follow up question - How did you convert the "SURVEY" tab into Weekly Summary? Thank you
Formula pls
Hi, how do the employees clock in and out for time to be entered in survey.. thanks
change yours survey and link it to your gsheet
Can you make a new video with all of the steps included? Your video is skipping steps that are important and causing me errors since each step is not clear.
Can you share the formulas please?