The Best Employee Timesheet using NFCs

  Рет қаралды 19,521

Unsubscribed Healthcare

Unsubscribed Healthcare

Жыл бұрын

Here is a video of an idea I had to automate attendance tracking or employee sign in using inexpensive NFC cards/chips. The idea is to program each NFC to submit a Google Form response automatically. The form response contains the employee's/student's/patient's name and ID number. This allows for you to keep track of each time they tap the card.
You could make it so that the employee has two cards one that designates clock in and another that designates clock out. That way it would be easier to keep track of in your Google Sheet.
Here is an amazon affiliate link for the NFC cards used in the video. #ad
amzn.to/3D9tSTQ
These are the ones I attach to my business cards to direct people to my website or give them my contact information right away.#commisionsearned
amzn.to/3H5qLxp
I imagine this could be really helpful for classes as well that require attendance.
If you would like to join the discussion on how to reduce your monthly costs as a healthcare business owner and request more how to videos please click this link below.
/ unsubscribedhealthcare
If you would like to purchase the pre-made templates or get a link for a FREE Superbill template follow the link below.
www.unsubscribed.healthcare/
As always remember to Subscribe to Unsubscribed Healthcare!

Пікірлер: 45
@FatJoeFilms
@FatJoeFilms 4 ай бұрын
I have searched for almost 12 months for this solution. I love the way you explain it as it is easy to understand. Love the demos to follow along. And of course, you project is super cool! I need hobbies and playing with stuff like this is going to be my new hobby. Thanks for sharing. Subscribed and liked
@unsubscribedhealthcare
@unsubscribedhealthcare 4 ай бұрын
I’m glad it helped! I actually had never used google sheets or Microsoft excel before starting these projects. It’s been a lot of fun learning how to make it all work :) I hope you have fun experimenting and please share what you make when you do!
@crissygiacona8022
@crissygiacona8022 25 күн бұрын
This looks great for my robotics team attendance!! Thanks
@k.r.j3475
@k.r.j3475 7 ай бұрын
This is EXACTLY what i was looking for! Thank you!
@unsubscribedhealthcare
@unsubscribedhealthcare 7 ай бұрын
You’re very welcome!
@mohammadumarshujath2217
@mohammadumarshujath2217 11 ай бұрын
Sir thank you very much for existing
@unsubscribedhealthcare
@unsubscribedhealthcare 7 ай бұрын
I’ll tell my parents you say thanks :)
@sungkim8258
@sungkim8258 28 күн бұрын
Love the comment below, "Sir thank you very much for existing" Thought same thing. Just an update I did, if you have many employees and this one page is filling with all employees,, I just created another tab, and used filter function to just filter 1 employee, and then to next tab. Calculating duration of lunch/break is easier.
@carlo.riente
@carlo.riente 10 ай бұрын
You rock ! Thank you so much
@unsubscribedhealthcare
@unsubscribedhealthcare 8 ай бұрын
You're welcome!
@daniellecopeland
@daniellecopeland 9 ай бұрын
You’re so smart! Help me brainstorm a way to track my time throughout the day. I need to track time spent on two jobs. I switch between the two jobs dozens of times each day. I’d like to use an nfc ring
@unsubscribedhealthcare
@unsubscribedhealthcare 8 ай бұрын
You could make two cards and have one keep track of one job and the other keep track of your second job. Just keep track by labeling the nfc you use. Then tap in and when you stop working that job tap that same card to log out. And then tap in to the second job and tap out again when you switch throughout the day. You could always add one more question and label it in and out and preset the answers to clock in and clock out. Tons of different possibilities
@aartj.5751
@aartj.5751 5 ай бұрын
very very super helpfull
@unsubscribedhealthcare
@unsubscribedhealthcare 5 ай бұрын
Glad it helped
@MauraPatterson
@MauraPatterson Жыл бұрын
This was so helpful!! I'm just wondering if I can put enough info on a tag that it shows clock in, clock out and breaks. Im guessing the name would just show up time stamped over and over and you would have to have a formula in your sheet to compute the total work time for each person. Anyway thanks a lot for this!
@unsubscribedhealthcare
@unsubscribedhealthcare Жыл бұрын
Thanks! You should be able to pre-fill the answers like I have done but then you could make it so they land on the second page and answer a question like "Please select" A) Clock in, B) Clock out, C) Break Clock Out, D) Break Clock In. That wouldnt make it as easy. The other option is to make the answers for each NFC chip so the employee would have 4 NFCS. One with the option for clock in. Clock out. Break In, and Break out. The answers would be logged into the google sheet for each card that they use. Its a little bit more cumbersome for the employees but could be done
@bendingreality-
@bendingreality- 6 ай бұрын
This is awesome, thanks! Is there a convenient way to separate the sign in and out times?
@unsubscribedhealthcare
@unsubscribedhealthcare 5 ай бұрын
The best way would to make two cards and have one of the answers be in or out.
@user-ls1rb8uv8w
@user-ls1rb8uv8w Жыл бұрын
Hi great video I was wondering if it is possible to add location at the time its taped a simple longitude and latitude so you know the tags are being taped in the right place?
@unsubscribedhealthcare
@unsubscribedhealthcare 8 ай бұрын
That is possible but it would require you to learn some coding and add a google script to it. I’m pretty sure you would only be allowed to do this if the person gave consent. I’ll look into it though!
@Richmanblog
@Richmanblog 2 ай бұрын
Hi! I am thinking about using similar approach for registering attendance at our youth center. What should I do in case I would like to add a predefined link to a mobile phone, so that youngsters could use their own phones instead of the nfc card?
@akkir6707
@akkir6707 3 ай бұрын
if this implement in rl application. its quite flawed since if i have a phone that a NFC reader and connected to the internet i can just tap the card to my phone and it will automatically clock me in right? even without going to the office personally lol. but very nice and straightforward nonetheless
@miguelcarrillo2927
@miguelcarrillo2927 6 ай бұрын
A very helpul video, im just wondering if they can tap and some way to put the store location, the reason im saying is because i have a retail store and for me is it will be better fot them to click and sent the actual location when they clock in if im not there
@unsubscribedhealthcare
@unsubscribedhealthcare 6 ай бұрын
I have a way to do it on Google sheets but not through Google forms. This way is the most simple way I know how to get it done without taking a ton of time.
@user-iv9uc4ww1t
@user-iv9uc4ww1t 4 ай бұрын
can you show how you do ? tq
@eliosrexhepi3239
@eliosrexhepi3239 5 ай бұрын
great video! is there a way i can store the NFC tag data even when i’m offline? and then sync the files once i get back online? thank you
@unsubscribedhealthcare
@unsubscribedhealthcare 5 ай бұрын
The NFC tag data is just the URL that you create. So it will remain on the NFC after you program it. I believe the submitted answers would require an internet connection to be submitted. You can then view the sheet after and see the updated form submissions.
@BakrSobashi
@BakrSobashi Жыл бұрын
I have same question
@Prime.Strength-Hyd
@Prime.Strength-Hyd Ай бұрын
This is good. But is it practically applicable? Because, any employee can easily check-in by just sitting at home and tapping the NFC card to his/her own phone that has NFC support. It will make an entry to the sheet. How do we avoid that? Probably the only way is keeping the NFC card at the reception of the office where an employee goes and collects his NFC Card everyday to Scan and mark his attendance.
@w33dp0w3r
@w33dp0w3r 5 ай бұрын
Looks nice, easy & simple.... but in case i have a nfc tag in a fix position on a wall let`s say and i want to register every single phone that taps my nfc tag and log their "uinque ID" ... how should i do it ? having a reversed scheme ... 1 phone receiving multiple nfc tags that have the embedded name/link on it it`s ok... functioning but i can`t see this as a clocking system. But having 1 tag and multiple phones ... kindda it is ! :) any thoughts ? Good job with the Spreadsheet.
@unsubscribedhealthcare
@unsubscribedhealthcare 5 ай бұрын
SO I have been thinking about this and couldnt figure it out before. This was the way that I came up with it the first time. I took a stab at it this week and figured out a way. You would need to have the employees logged into their gmail but you could make their unique ID based on their Google account. Ill make a video on it. You can have one tag be In and another tag be Out. Could also make it so there is just one place to tap for students signing into a class. The user just has to check one box and then hit submit. So still not as long as filling out all of their information.
@noface6811
@noface6811 Жыл бұрын
VERY HELPFUL!! but may I ask if there is anyway that the nfc tag can only be tapped in only a specific device? since I suppose anyone can just input their attendance using their phones even if they really didn’t go in for work or school 😞
@BakrSobashi
@BakrSobashi Жыл бұрын
I have same question
@unsubscribedhealthcare
@unsubscribedhealthcare 8 ай бұрын
The only option I can think of is using google script to obtain the current location of the person submitting the form. I’ll work on it.
@andreasfreyaldenhoven5785
@andreasfreyaldenhoven5785 10 ай бұрын
Great video but would it be possible to make it so that it automatically checks in the user without them having to click the browser link?
@unsubscribedhealthcare
@unsubscribedhealthcare 8 ай бұрын
Thats one of the downsides of using Google Forms is that it is only possible if they click the link. I think you would need a custom software otherwise :/
@THX-pc9zq
@THX-pc9zq 7 ай бұрын
GAS (Google Apps Script) can perform that function but it is much more difficult to program. This is the easiest way that I have seen so far.
@DerlinSantana
@DerlinSantana 4 ай бұрын
What happens if the students/employees scan the tag with their phone? they'll be able to mark them on time, won't they?
@unsubscribedhealthcare
@unsubscribedhealthcare 4 ай бұрын
That is true. They would be able to. The other solution is to keep them in the class or at the office and have them tap it and then place it back into its spot. Kinda like an old punch card
@adriancarmona6025
@adriancarmona6025 10 ай бұрын
Where Can I get one of those RC or robot whichever?
@unsubscribedhealthcare
@unsubscribedhealthcare 8 ай бұрын
Most phones will be able to do it. If you have an old one laying around that should work! Otherwise you could look for an old tablet that has an nfc chip/reader in it
@PooyaRahbaran
@PooyaRahbaran 4 ай бұрын
how should we fix this error? "Sorry, unable to open the file at this time. Please check the address and try again."
@unsubscribedhealthcare
@unsubscribedhealthcare 4 ай бұрын
That probably has to do with your share settings. If you go into the share in the top right of the form you will be able to change it so anyone can access the form. That should fix the issue
@richyluk
@richyluk Ай бұрын
Can't avoid cheating.
@BakrSobashi
@BakrSobashi Жыл бұрын
I have same question
Employee Timesheet Using Google Forms and Google Sheets
6:55
Unsubscribed Healthcare
Рет қаралды 29 М.
NFC vs. RFID: What’s the Difference?
2:47
Eye on Tech
Рет қаралды 117 М.
Must-have gadget for every toilet! 🤩 #gadget
00:27
GiGaZoom
Рет қаралды 12 МЛН
Check in / out Google Sheets
12:05
The Mobile Sales Engineer
Рет қаралды 186 М.
NFC Automation Ideas to UPGRADE Your Smart Home!
11:42
WyattTech
Рет қаралды 22 М.
NFC or QR payment? The endless debate
5:10
PaymentGenes
Рет қаралды 22 М.
I created my own NFC Business Card - Here's what happened...
11:40
NFC Tags and Digital Business Cards - Easy 25¢ DIY!
11:30
Sudo Scientific
Рет қаралды 10 М.
PowerApps Read NFC Tag to manage inventory
11:17
Shane Young
Рет қаралды 25 М.
15 Creative Ideas To USE NFC Tags For Home Automation in 2022
7:59
Automated Tech
Рет қаралды 29 М.
USING NFC FOR INVENTORY MANAGEMENT
1:41
Purple Deck
Рет қаралды 16 М.
Choosing the Best RFID Tags: 7 Factors to Consider
1:01:01
atlasRFIDstore
Рет қаралды 1,6 М.
How you can use NFC to improve your everyday life!
15:43
Caddac
Рет қаралды 20 М.