#155-How to make an Automated Attendance Sheet in Google Sheets

In this video, you will learn How to create an automated attendance sheet in google sheets with google app script. I think you have not seen this type of video on Youtube. So enjoy the video and if you face any problem write me in the comment section.
***********************************************************

~:Related Video Links:~
***********************************************************

Related Video Links:
***********************************************************

You need to understand few things to create this template, so watch this video:
***********************************************************

~:Support Our Work Financially:~
***********************************************************

~:Join us on Social Media :~
***********************************************************

~:Hire Me:~
If want me to help you to build Excel-based applications, you can Hire ME!
***********************************************************

~:Sponsored:~

***********************************************************

[SahaComputer]

Hi, Viewers if you have problem regarding this tutorial, you can write me in the comment section.👇

[Rimjeet]

Sir apnar ei video khub valo legeche
Amio ei rokom ekta sheet creat korte chai
Kintu amader month start hoy jemon 6 Jun to jul 5.

Amader morning, evening and night shift hoy

National holiday duty hoy eveni morning night shif a

Ekhane amader count korte hoy koto gulo national holiday te duty koreche


Apni ki ektu help korte parben.

Korle khub upokar hoto

[masudar]

Great tutorial!!! Great Teacher!!!!😍🥰❤💥 Following along without hearing a thing... computer issues.

[AzeemKhan-jwmh]

Very very informative video sir. I like this very much. But one thing i want to know that how we can create of whole the year. Also tell me how can i get your this, Please do tell me.

[jeetendrachopra]

if a person also present on weekend and or holiday then how allow him an extra attendance or overtime

[lauramurphy]

Hi there, I have followed your tutorial and developed a great annual leave calendar however, 2 things:
1) My script does not seem to work at all - I have followed your guidance, but I receive the message: Script function ClearCells could not be found.
2) I see others commenting about the content being the same for each month, which I have found too, and you say to copy a master sheet for each month - but it's not clear what you mean, or how to do that, can you provide a video of how to do that, or some detail please as this becomes pointless without it? The other video you direct to is losing me. Thanks

[sadeeshanatomy]

Congrats, its very useful video and simple too. it can be used for the classes also. Is it possible to prevent over writing of attendence for previous day

[Rimjeet]

There is a problem here, the present is not changing when the month changes. The previous present here is therefore changing the month when coming

[bunthonmok]

Thanks, this tutorial is useful ...!!!

[jeetendrachopra]

How could you allow all the weekends and or holidays to an employee who joined or left at middle and or after/before certain weekends or a holiday(s)

[Psygnosis]

very useful video. thank you. But is there a way to retain the data attendance data when i switch between months when click the Month drop down menu?

[yabado]

i can't see the extentions tab..? how to enable it. mine is just add-ons

[Crystaldesigns]

Hi, Please confirm how can we get attendance input from google form in same sheet.
Thanks

[carlaafidchao]

Hello, thank you for this video. I have a concern tho, I'm not sure on how I can clear the data (P, A) if I change it to another month? Because when I change it to other months, same data is there. Would appreciate a feedback. Thank you.

[melissalasig]

Hi what did you click at 11:02 min. Is that a comma after +1? when I put comma it is showing error.

[apoorvakhodiyar]

sir, I make this Google Sheets it's very working easily but some errors come in the weekend part all sections show 0 not 1 as a weekend

[deependrapaudel]

how to indicate if some one worked at holiday or weekend if there is provision of overtime pay or compensation leave

[hudaalraee]

I was waiting for you to explain how do I can save my data
what if I change the month to FEB how can I know that Attendance of JAN and How can I know the report for All month
I need your answer Please

[juvyfestijo]

What if we had day shift and night shift schedule. How? could shifting schedule per week will automatically posted by the end of the week (sunday)

[naveenms]

Hi Sir I prepared Automatically attendance sheet based on your video. but we need 8 to 9 sheets how to copy paste same format and formulas and date and att all ?