Fully Automatic Employee Login & Logout Time Tracking System - FREE for Use - Excel Dose
Вставка
- Опубліковано 17 бер 2023
- Are you tired of manually tracking your employees' work hours? Do you need a more efficient way to monitor employee attendance and calculate payroll? If so, you may want to consider implementing an Employee Login & Logout Time Tracking System using Google Sheets and Google Apps Script.
In this video, we'll walk you through how to set up a simple time tracking system that allows your employees to log in and out of work using a shared Google Sheets spreadsheet. We'll also show you how to use Google Apps Script to automate the process of recording and storing employee attendance data, which can then be used to generate accurate payroll reports.
By the end of this video, you'll have a basic understanding of how to create a customized time tracking system that meets the specific needs of your business. So whether you're a small business owner or a manager of a large team, this video is a great resource for anyone looking to streamline their employee attendance tracking process.
Main Sheet Link: docs.google.com/spreadsheets/...
Code link: docs.google.com/document/d/1O...
------------------------------------------
Daily Hot Deals : exceldose.com/todays-deals/
***************************
Subscribe: ua-cam.com/users/exceldose?s...
Follow us on Facebook: / exceldose
Website: exceldose.com
Follow us on Instagram: / exceldose
Wow this is a great project. Simple and efficient
Thank you 😊
Great work, Thanks for your amazing efforts. 👏
Glad to hear! Hope you have subscribed to our channel.
thanks for this! great job!
You’re welcome 😇 I hope you have subscribed to our channel 🙏
Thanks for this! Great work! Do you think it is possible to use with multiple people? I was hoping to list 4 employee names in the main sheet
In that case you need to make a multiple copy of Vishal tab and then use it
Thank you for this, I am having trouble recording accurate times for all the employees. It works fine for the first employee entered, but the second one I enter doesn't work. When I try to login the second employee, it only updates the time for the first employee on the sheet. Do you know how I can fix this issue?
Make a copy of the tab for each employee and then see if it works. Ideally this should not happen
😮😮
👏🏼
it looks great but it seems to want access to my entire google sheets. help?
Yes you have to grant permission to access the sheet
You need to give access to run the script
Can I have a copy of this for my small business? Thank you.
Copy has been shared with you.
Hi i want to add more column in existing sheet can be possible how i can edit
Replied to your email
But I notice, the button is not working on mobile phone. Is there a way around it?
The script created based on web so it may not work on phone. There is no workaround for this version
@@ExcelDose okay. Thanks
Hello. I’m requesting for access since it’s not working on my end
Can you please share a file with us info@exceldose.com
Can u show how to built an app with these?
We have created similar video. Hope that will help you Create a Patient or Visitor Data Entry Form with Google HTML Service & Submit Data to Google Sheets
ua-cam.com/video/zcFaKgjvM10/v-deo.html
How to get the time synced with my laptop time?
Hi Jhumel, We have re-write the code to get the time synced with the laptop. Please check the code again. docs.google.com/document/d/1OSD9KRDqR68AUYkCGz1fLHbWOWXqtTGW5XRGMPSQtrc/edit
How to add that login time button and assign the script
Once you make a copy of the sheet. It will be automatically added. Else you can click on Insert --> Drawing --> Then draw the button and later you can assign the script
Can i have copy on this, thankyou
Main sheet link is mentioned in the video description. Please make a copy and start using it. Thank you 🙏
How do you create the butons
You can click on Edit option and then select Drawing. In that you can create a button
can u plz explain it after copying of formula
What help you are looking for?
Is there a step process of creating it
In video we have explained each step
How can I download the app?
This is made in Google AppScript
hi i want this sheet
Access has been shared
I can't edit this spreadsheet
Make a copy and then use
How do I get the codes please
Code is mentioned in the video description
Can i have a copy of this
You can make a copy of the sheet and then use it.
I cannot use the buttons
Make a copy and then use it
Please share me that copy plz plz
Please make a copy of the sheet mentioned in the video description.
Hi can i request for the codes 😊
Once you make a copy - then code will also be copied. You can check in AppScript option of the same sheet
Hi can i request for the codes 😊 thanks
When you make a copy of the sheet the code will also be copied. You can see the code in the appscript option of the same sheet
Code link: docs.google.com/document/d/1OSD9KRDqR68AUYkCGz1fLHbWOWXqtTGW5XRGMPSQtrc/copy
I see only id etc but i dont see those buttons like login submit@@ExcelDose
script is asking for permission
Grant the access so the script should run
@@ExcelDosehi sir please share with me copy of XSLM files plz
I am unable to use the buttons.
Shared copy with you
Can I have a copy of this for my small business? Thank you.
Sheet link is mentioned in video description docs.google.com/spreadsheets/d/1MzkMbQBpjbN2cAICc8O4vgRF0AiBHjhO_BpAr1nFX0g/