#142

[@taslimanasreen8432]

I have doubt, if i change to new month , automatically all the days should get cleared, and if i go back and select the previous month, all the entries should remain same , how to do that

[@stonespider]

I had filled out the google form (given in the description box) requesting this excel template and received it in my mail within a week. Thank you.

[@SahaComputer]

Thanks for your comment.

[@stonespider]

@@SahaComputerI have a question for you. Google sheet is integrated with class exam paper and the students can attempt the exams multiple times but I want to keep only the first attempt and eradicate the multiple exam attempts (duplicate rows result entries, i.e duplicate admission numbers ) via Sorting the 'Admission number' column (since admission numbers are iunique). (The sheet also has a Timestamp column). So how can I create a range, use a a formula etc to remove the duplicate exam attempts (remove the duplicate rows)? Thank you.

[@SahaComputer]

I want to know about your exam paper. Is it made with google form or any other.?

[@stonespider]

@@SahaComputer yes exactly.. Google Form. So the Google sheet I am referring to is the responses sheet.

[@SahaComputer]

So there is a option to take only one response from one user.

[@hrmanager8887]

Sir after preparing the attendance sheet. When I added more employees weekend helpers and holiday helpers didn't highlight. So what do we have to do next, we have to the color by ourselves or another option for an automatic fill-up.

[@SahaComputer]

you have to increase the range of conditional formatting.

[@Sniperguy35]

Hello, I am a teacher online and I want to track my students attendance on Zoom. Will that work for me you think or would you recommend something better? Also, am I able to get this on my email?

[@subhodiproy89]

If we select July and when I change to august it all data copied to august ,how to make it correct ?

[@SahaComputer]

When you completed your July Attendance then copy that sheet and rename it as July'2021 the Clear the master sheet and change it to August and start do your attendance for August. I trying to do what you are expecting.

[@sumananag4234]

Hello, You have built a very efficient attendance system. However I would like to copy the absentees of a particular day to another sheet. Kindly help.

[@SahaComputer]

I will try to make and create a tutorial video on it.

[@Akshithagowdacp]

Hello sir, plz share the link of this video to create the attendance in google sheet

[@SahaComputer]

Watch this video you can create the file: kzbin.info/www/bejne/ppKUgKyYibmYaNU

[@nigelwalker6443]

Ok...my thing is...I want the students to mark their names when they enter their google classroom...like say, when they are in the google classroom they will click on that google sheet and mark their names for that particular day. So...You need to show what it looks like from the students end....and therefore, I will see it from the teachers end the students attendance as they are entering online in the google classroom. Thanks.

[@SahaComputer]

You can also do this by sharing a attendance form with student who will do their attendance with this form and the data will be received in google sheet. You can see the report of the attendance database in another sheet of same google sheet file. Presently I am working on it and I will upload the tutorial as soon as I complete.

[@manikya9248]

SIR MERE ATTENDANCE SHEET PE DATE AND MONTH TO CHANGE HO RAHI HA BUT JO DATA FILL KAR RAHA HU BO CHANGE NAHI HO RAHA HA PLEASE HELP

[@Sh-iu7mp]

If you change month in the above what happens all the attendance are same to the selected month also that's is bad

[@SahaComputer]

Actually this is single moth sheet, you have to a single sheet for whole year then you can achieve what you want. I giving a reference of a excel video you can watch it. kzbin.info/www/bejne/Z6WqhKOflJl1ldE And I will also make a video for google sheet also.

[@jungonzales2301]

@@SahaComputer Do you Have a full year for GoogleSheet?

[@SahaComputer]

Not yet but I will create soon & upload.

[@backofficearchtech6250]

i want today's present & Absent

[@avinashkori1217]

Bhai its a all good but please explained how's ready to format

[@SahaComputer]

Watch this Video: kzbin.info/www/bejne/ppKUgKyYibmYaNU

[@NoorAhmed-xn5yt]

Plz tell how we can make it

[@SahaComputer]

Send me you mail address.

[@NoorAhmed-xn5yt]

[e-mail]

[@SahaComputer]

File sent

[@muhamadshuhaib]

@@SahaComputer [e-mail]

[@muhamadshuhaib]

@@SahaComputer Sir plz tell to me how build that's?

[@Sh-iu7mp]

Sir plz show each month attendance saves dynamically through this app

[@SahaComputer]

You have to create full year sheet.

[@ranganathaks748]

How to create above attendence show me please and upload video sir

[@SahaComputer]

kzbin.info/www/bejne/ppKUgKyYibmYaNU&lc

[@divyarani2747]

How to make this sheet..... I don't understand you only explain not show how to make.....

[@SahaComputer]

kzbin.info/www/bejne/ppKUgKyYibmYaNU