No video

google sheets attendance tracker | free addon

  Рет қаралды 108,902

Codician

Codician

Күн бұрын

google sheets attendance tracker | free addon
install attendance tracker (gsuite link)
gsuite.google....
How to use attendance tracker (guide)
attendancetrac...
OTHER FREE ADDONS
TIME TRACKER
gsuite.google....
MERGE SHEETS
gsuite.google....
EXCEL/VBA AUTOMATION'S
how to merge excel files
• how to merge multiple ...
Send bulk emails in outlook
• how to send bulk email...
extract outlook attachments
• how to extract outlook...
connect excel to access
• access connector | con...
time tracker / timesheet
• vba time and motion to...
automated workflow designer
• automated workflow in ...
google sheets,
attendance sheets,
time tracker addon,
time and motion tracker,
google sheets,
google scripting, www.buymeacoff...
github.com/dee... FOR CUSTOMIZATION VISIT www.fiverr.com...

Пікірлер: 70
@maleehahaider8596
@maleehahaider8596 3 жыл бұрын
Awesome App! Solution to my problem! God bless you. But please a little request, can you add a totalling functionality in which each months absent percentage is calculated i.e. (days absent / total working days )* 100 . Second , a graph for the whole class with each childs monthly attendance and also total attendance percentage over a range of selected months. Hoping you will get back to me on this. Thankyou!
@_aarti_sangrah
@_aarti_sangrah 3 жыл бұрын
thanks for the video it helps a lot for the people like us who doesn't know about these things
@ansarimohd.5881
@ansarimohd.5881 4 жыл бұрын
Very nice app , i appreciate your work.But i recommend you one modification in your "attendance tracker add on", please make provision to enter only absent roll No.it will be more useful to us. Only we enter absent student roll nos & indirectly other students will be automatically mark as present.........
@Codician
@Codician 4 жыл бұрын
thank you , in that case you can select that row for now .
@Mahmood-
@Mahmood- 3 жыл бұрын
I liked your presentation very much.
@Codician
@Codician 3 жыл бұрын
thank you
@jaysagmit3794
@jaysagmit3794 3 жыл бұрын
Do u have a video about employee attendance, where there is time in and out?
@McDeslandes
@McDeslandes Жыл бұрын
It's not what I need, but I loved the video!! Thanks :)
@Codician
@Codician Жыл бұрын
there is MS Excel tracker also available in my playlist
@siputrumah5253
@siputrumah5253 4 жыл бұрын
I hope the user can fill that data from a form... but this add on is just for administrator ( he/she fill the sheet by his/her self)
@TheSocialjerry
@TheSocialjerry 3 жыл бұрын
This is brilliant!!!!
@Codician
@Codician 3 жыл бұрын
Thanks
@growingyouthstech726
@growingyouthstech726 2 жыл бұрын
Thanks really helped me a lot
@sirdelord02
@sirdelord02 2 жыл бұрын
excellent
@shubharangaswamy0508
@shubharangaswamy0508 3 жыл бұрын
I am a teacher, we take attendance every period. Is that possible with Google sheetz.
@Codician
@Codician 3 жыл бұрын
Yes
@plutusias
@plutusias Жыл бұрын
how to add present and absents in m0onths
@Codician
@Codician 10 ай бұрын
use auto attendance feature shown in video
@loaf9672
@loaf9672 8 ай бұрын
Mate, I've trying to make something similar with checkboxes to track my patient's attendance. So on two separate dropdowns, I'd like to select the patient's name and the month. By selecting those, the attendance table would get updated and show me the records for that particular patient in the selected month. I'm two week into it already and nothing. Do you know how to work around it?
@Codician
@Codician 8 ай бұрын
may be this can help infoinspired.com/google-docs/spreadsheet/auto-populate-information-based-on-drop-down-selection/
@marihansen6299
@marihansen6299 3 жыл бұрын
i tried to use Attendance Tracker v2.0 Your addon is loaded. When i click on "fill header" - first two rows are filled with content. Dates look like 2-Apr.-2021 in first row - that is okay looks a little strange to me. But you used a formula to display name of day ( =text(E1, "ddd") ) that shows #Error in my case. =text(E1; "ddd") this formula works for me.
@Codician
@Codician 3 жыл бұрын
Are u in eu region ?
@westernsolarsystems819
@westernsolarsystems819 3 жыл бұрын
Can we edit the start date & end date? example: 10th to 10th of every month
@dr.bhavinmodi6935
@dr.bhavinmodi6935 3 жыл бұрын
Very nice 👌 Thanks a lot.. I need a help from you to create userform to record my patients record for my clinic with the help of google sheets. Will you plz guide?
@Codician
@Codician 3 жыл бұрын
you can use HTML in creating userform in google sheets
@dr.bhavinmodi6935
@dr.bhavinmodi6935 3 жыл бұрын
@@Codician Thanks bro Any demo plz🙏
@happyhealthyvibes4477
@happyhealthyvibes4477 3 жыл бұрын
hello , I'm using this sheet after watching your video.. Thank you so much ! but the autofill option is not working now when I added new month ..
@Codician
@Codician 3 жыл бұрын
i m not sure how you are adding new month. you have to add new sheet and then refresh and choose new month from the dropdown and autofill ( just refresh or reload it should work)
3 жыл бұрын
Hello, is it possible to change the mark attendance values for employees?? like instead of "P", i could put "M" for morning or "N" for Night?
@Codician
@Codician 3 жыл бұрын
Good idea
@tristanarmstrong3442
@tristanarmstrong3442 2 жыл бұрын
How would I terminate and make it stop calculating attendence on one particular emplyee?
@Codician
@Codician 2 жыл бұрын
its very much manual . if you are giving sheets access to ur empyloyees you can just restrict that .
@shakshisoni
@shakshisoni 3 жыл бұрын
In the same sheet how to enter the next month.. it is only placing the next month in 1 and 2 row
@Codician
@Codician 3 жыл бұрын
create a new sheet and then use header option to fill that .
@artofnursing5049
@artofnursing5049 3 жыл бұрын
I want to know abt Google sheet where the participants can type their names and put a p in a session for a webinar
@Codician
@Codician 3 жыл бұрын
share sheet to them so that they can enter . its a common sheet so anyone can put attendance for anyone . there is no procedure to share a cell or a row
@sumanadhikari9609
@sumanadhikari9609 2 жыл бұрын
Good
@Codician
@Codician 2 жыл бұрын
thank you 🙏
@nkarthikeya8113
@nkarthikeya8113 3 жыл бұрын
Thank you
@Codician
@Codician 3 жыл бұрын
Thanks
@ExtremeMith5
@ExtremeMith5 Жыл бұрын
How do i get only mon - fri days or only every monday etc...
@Codician
@Codician Жыл бұрын
If you are saying that only monday should be touched . In that case if its blank then we can fill it . But in case you want to replace monday with new values then you would need to select each monday column manually and update values
@twinkledey9208
@twinkledey9208 2 жыл бұрын
Is it track from google classroom??
@bijanbaniasadi6559
@bijanbaniasadi6559 2 жыл бұрын
Thanks
@janevanessaa3523
@janevanessaa3523 3 жыл бұрын
hi. i couldnt find the apps when using my phone.only in computer. can u help?
@Codician
@Codician 3 жыл бұрын
It supported on browser only by Google .
@_aawara.musafir_6104
@_aawara.musafir_6104 4 жыл бұрын
Can we attach this spreadsheet to google form
@Codician
@Codician 4 жыл бұрын
you do anything with this sheet as long as google has this feature or allows
@deanacademy9201
@deanacademy9201 4 жыл бұрын
Yes, can you demonstrate a form being added. I tried but my form entries were overridden by the load of the tracker
@bittertruth27
@bittertruth27 3 жыл бұрын
Does this work on mobile..
@ahmedlatheeph
@ahmedlatheeph Жыл бұрын
can we ad and edit type of leaves?
@Codician
@Codician Жыл бұрын
yes
@ahmedlatheeph
@ahmedlatheeph Жыл бұрын
@@Codician sir how can i contact you other than this.. thank you
@Codician
@Codician Жыл бұрын
@@ahmedlatheeph dlohia.com/contactus
@jessajohnson9580
@jessajohnson9580 3 жыл бұрын
I dont know how to change the status from P to AB can you help?
@jessajohnson9580
@jessajohnson9580 3 жыл бұрын
NVM got it
@Codician
@Codician 3 жыл бұрын
Find and replace
@user-rq2eb2ii5y
@user-rq2eb2ii5y 6 ай бұрын
Can I add my own attendance codes
@Codician
@Codician 6 ай бұрын
yes you can . look for google sheets app script.
@thechillpod4368
@thechillpod4368 4 жыл бұрын
I cant add header while clicking on it?
@Codician
@Codician 4 жыл бұрын
try on google chrome . and ensure that java script is enabled on google chrome .
@MrBilly0071
@MrBilly0071 3 жыл бұрын
Can we install add-ons in mobile??
@Codician
@Codician 3 жыл бұрын
I am not sure if google supports that
@wallaceanjos
@wallaceanjos 2 жыл бұрын
not working here in brazil
@Codician
@Codician 2 жыл бұрын
Any specific error or time issue ?
@wallaceanjos
@wallaceanjos 2 жыл бұрын
@@Codician no, it just do not work, when I click on fill head it gives no response
@Codician
@Codician 2 жыл бұрын
@@wallaceanjos i tested on Chrome and Edge its working fine. but if you are still facing issue uninstall it and re-install from google marketplace .
@988521
@988521 3 жыл бұрын
IF U CAN ADD MOBILE NO IT WILL BE AWESOME ADDON
how to combine sheets using google sheets add-on
2:48
Codician
Рет қаралды 3,4 М.
How to Build an Attendance Tracker in Google Sheets
14:48
Spreadsheet Life
Рет қаралды 53 М.
OMG what happened??😳 filaretiki family✨ #social
01:00
Filaretiki
Рет қаралды 13 МЛН
English or Spanish 🤣
00:16
GL Show
Рет қаралды 8 МЛН
The CUTEST flower girl on YouTube (2019-2024)
00:10
Hungry FAM
Рет қаралды 3,5 МЛН
When you discover a family secret
00:59
im_siowei
Рет қаралды 23 МЛН
Classroom Attendance Report Spreadsheet in Google Sheets
41:40
DobroSKILLS
Рет қаралды 49 М.
Automated Attendance Sheet in Excel
41:46
PK: An Excel Expert
Рет қаралды 317 М.
5 Google Sheets Tips Every User Should Know!
12:02
Simpletivity
Рет қаралды 671 М.
Google Sheets - Add Timestamp When Cell Changes - Apps Script
16:39
Learn Google Sheets & Excel Spreadsheets
Рет қаралды 335 М.
Check in / out Google Sheets
12:05
The Mobile Sales Engineer
Рет қаралды 195 М.
Student attendance template in Google Sheets
8:04
Sheetgo
Рет қаралды 24 М.
#142-Automated Attendance Sheet in Google Spreadsheet (2021)
10:14
Saha Computer Education Centre
Рет қаралды 25 М.
OMG what happened??😳 filaretiki family✨ #social
01:00
Filaretiki
Рет қаралды 13 МЛН