Long Company Name Fix
1:40
7 ай бұрын
How to Lock Files on Google Drive
1:35
Copy Folders on Google Drive
4:02
Chat GPT: Forms to Sheets to PDF
9:12
Пікірлер
@somsakwongpipit6306
@somsakwongpipit6306 Күн бұрын
Thank you for your sharing auto submitting Google Form with NFC. But if I use Microsoft Form, How I should add or change any text on URL? Please suggest me if you know. Thank you again.
@geniuscoinacademy
@geniuscoinacademy 3 күн бұрын
How can we create a username and password for each person to enter this form? that no one can register anything for another
@crissygiacona8022
@crissygiacona8022 Ай бұрын
This looks great for my robotics team attendance!! Thanks
@sungkim8258
@sungkim8258 Ай бұрын
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.
@laurahaladay5247
@laurahaladay5247 Ай бұрын
written guide please
@marisamena848
@marisamena848 Ай бұрын
This was so helpful thank you
@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.
@richyluk
@richyluk 2 ай бұрын
Can't avoid cheating.
@midwifelouisianallc44
@midwifelouisianallc44 2 ай бұрын
Thanks again. Quick question: is there a benefit to logging in with the form over simply logging into Google account? I use Google Sites as my patient portal. Each patient gets their own site with areas devoted to their chart, educational materials, informed consents folder and billing information. After the initial set up, it auto edits in real time when I work in Sheets.
@A-oj4ch
@A-oj4ch 2 ай бұрын
Thank you for sharing your helpful approach! I'm trying to set up something similar - is this approach HIPAA compliant?
@midwifelouisianallc44
@midwifelouisianallc44 2 ай бұрын
@@A-oj4ch Being that everything is through Google Workspace, and both sections to sign for compliance were checked, it should be HIPAA compliant. Each Site is shared with that patient only, and they create their own log in. It has worked well so far, and is very attractive and organized.
@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?
@AFatOcelot
@AFatOcelot 2 ай бұрын
wtf this feature is gone now why
@nextlevelmovementpt
@nextlevelmovementpt 3 ай бұрын
Can you record multiple outcome measures? I often use a handful of these, and would love for this feature to allow me to record all the scores and carry them all forward for me in the Eval sheet.
@nextlevelmovementpt
@nextlevelmovementpt 3 ай бұрын
Should this modification be done in each template in the PT Templates folder?
@stephaniem8927
@stephaniem8927 3 ай бұрын
This is exactly what I have been looking for. I have a Medicare business and I need something that’s HIPAA compliant and easy for my clients to use.
@SunshineUnterwagner
@SunshineUnterwagner 3 ай бұрын
How much do you charge for the template? How do you "order" it?
@akkir6707
@akkir6707 4 ай бұрын
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
@darlenepoisson4659
@darlenepoisson4659 4 ай бұрын
This doesn't work very well because the employee self reports the times they come in and out. A "Clock In"-"Clock Out" form will automatically put the times in. However each entry, being on a new line, prevents you from being able to calculate hours worked. I have searched and searched for a solution but can't find one.
@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!
@kristinapendergrass2008
@kristinapendergrass2008 4 ай бұрын
Thank you: this helped me set up a way to collect timesheets from employees. :-)
@unsubscribedhealthcare
@unsubscribedhealthcare 4 ай бұрын
Glad it helped!
@ezinnenjoku3626
@ezinnenjoku3626 4 ай бұрын
Great video. Is this still in beta? I tried to use it last month and when I sent it to the client, ir remained locked. They couldn't access the document to sign it.
@unsubscribedhealthcare
@unsubscribedhealthcare 4 ай бұрын
Yeah I have it almost done. The tricky part is getting my patients to sign it correctly. Some of them are not tech savvy and it requires a computer for the way I have it set up currently.
@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
@user-bn2qu1yo5n
@user-bn2qu1yo5n 5 ай бұрын
How do you know what to put in the “amount section”? If I charge $150 a session, I add that for the promos pay adjustment… how do I know what to put in the price per unit/amount sections? Thanks!
@unsubscribedhealthcare
@unsubscribedhealthcare 4 ай бұрын
What I was told was to put down roughly 2x the amount Medicare pays for reimbursement. So for therex, neuro, therapeutic activities, it would be $75, manual would be $50 and eval would be $2-300.
@DerlinSantana
@DerlinSantana 5 ай бұрын
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
@REI_Nate
@REI_Nate 5 ай бұрын
Great template! Is there a way to add numbers to the boxes for people to pick a numbered square more easily?
@unsubscribedhealthcare
@unsubscribedhealthcare 4 ай бұрын
So the way that I have played squares was that it was randomly assigned. Otherwise everyone would go for squares 0,0 or 0,3 or 0,7. The squares with the less common scores would not be picked or people wouldn’t play if they couldn’t get a “good” square. That’s why it’s meant to be random. You can always click the button to assign the squares and then have people fill it in.
@REI_Nate
@REI_Nate 4 ай бұрын
@@unsubscribedhealthcare I more so meant in the squares for 0-100. I definitely play squares the same way with the randomizer. For example someone wants to pick squares 12, 18, and 37, it would be easier if it had numbers labeled on the grid
@unsubscribedhealthcare
@unsubscribedhealthcare 4 ай бұрын
@@REI_NateI get what you’re saying. I’ll look into adding a form to allow people to select a square.
@tzm1843
@tzm1843 5 ай бұрын
That has NOTHING to do with Google Drive! You should edit the title to How to Lock a PDF in Mac OS.... (I got here looking for a solution for Google Docs or Linux!)
@hulksmash5150
@hulksmash5150 5 ай бұрын
Generate Random Numbers only seams to work for away team.
@unsubscribedhealthcare
@unsubscribedhealthcare 5 ай бұрын
I took a look at it and to fix this you need to click on the time that appears when you click the box to generate numbers and format it so there is no AM or PM so that it is just the numbers. If you download it again it should be fixed. Thanks for catching that!
@aartj.5751
@aartj.5751 5 ай бұрын
very very super helpfull
@unsubscribedhealthcare
@unsubscribedhealthcare 5 ай бұрын
Glad it helped
@zacschmelzer8487
@zacschmelzer8487 5 ай бұрын
what if we need to deduct lunch time?
@unsubscribedhealthcare
@unsubscribedhealthcare 5 ай бұрын
You could add either two columns for time out for lunch and then time in for lunch. The subtract the total hours by the lunch time or you could have them just fill out time taken off for lunch and subtract that from the total time
@thepragmaticidealist4015
@thepragmaticidealist4015 5 ай бұрын
Thanks! This video was very helpful!
@unsubscribedhealthcare
@unsubscribedhealthcare 5 ай бұрын
You're welcome!
@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.
@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.
@mikemathias675
@mikemathias675 6 ай бұрын
🤯 Amazing
@unsubscribedhealthcare
@unsubscribedhealthcare 5 ай бұрын
Thank you! Its taken a lot of work to get here. :)
@user-zu9qu7bi8m
@user-zu9qu7bi8m 6 ай бұрын
I love this instruction. This is going to be very helpful. I am attempting to receive docs from client. I will not be uploading any Docs to client folder but, I will receive them to their folder. Would this be the same steps and linking? Once I follow steps and I do not upload a doc to send, they can set up password and access their folder to send docs? Thanks so much- Very helpful
@unsubscribedhealthcare
@unsubscribedhealthcare 5 ай бұрын
Im not sure
@patrickg4830
@patrickg4830 6 ай бұрын
💪 Promo*SM
@bendingreality-
@bendingreality- 6 ай бұрын
This is awesome, thanks! Is there a convenient way to separate the sign in and out times?
@unsubscribedhealthcare
@unsubscribedhealthcare 6 ай бұрын
The best way would to make two cards and have one of the answers be in or out.
@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 5 ай бұрын
can you show how you do ? tq
@user-io5ld3vu7p
@user-io5ld3vu7p 7 ай бұрын
The sweetest voice of your son :)))
@unsubscribedhealthcare
@unsubscribedhealthcare 6 ай бұрын
They grow up so fast :)
@vanessaviruet9615
@vanessaviruet9615 7 ай бұрын
Hi, but how do you bill the encounter? Where does it go from there?
@unsubscribedhealthcare
@unsubscribedhealthcare 6 ай бұрын
You have a couple options. You could use a Mac portal for Medicare patients, you could use a clearing house, or you could make a CMS 1500 form and mail it to the insurance company
@nextlevelmovementpt
@nextlevelmovementpt 7 ай бұрын
Great walkthrough! If I want to create several Superbills at one time and save one giant PDF of them, would I just copy-paste all the columns and rows that have any content in them and create multiple sheets in the same document?
@unsubscribedhealthcare
@unsubscribedhealthcare 7 ай бұрын
This template is ideal for a one at a time approach. To save it as one pdf with multiple you would want to copy and paste the template in the same columns below the last row. You will then fill out the information again and continue pasting. You will have to make sure that you get the page breaks set correctly when you save it as a pdf. Otherwise you could get half of the Superbill on the same page as the Superbill above it. I hope that makes sense.
@nextlevelmovementpt
@nextlevelmovementpt 7 ай бұрын
@@unsubscribedhealthcare Thanks! I did end up finding that it was much better suited for doing each individual visit. It was surprisingly simple and quick, once I got everything set up!
@unsubscribedhealthcare
@unsubscribedhealthcare 7 ай бұрын
@@nextlevelmovementpt that was the goal :)
@embodyingfreedom6663
@embodyingfreedom6663 7 ай бұрын
How can I get this without the full PT package?
@unsubscribedhealthcare
@unsubscribedhealthcare 7 ай бұрын
Are you talking about just the templates without all the automation?
@maryagrasya344
@maryagrasya344 7 ай бұрын
What is the code that you should put to cover more cells?
@unsubscribedhealthcare
@unsubscribedhealthcare 7 ай бұрын
Are you asking for it to populate in more separate cells or like a set of merged cells
@sanketvhaval6113
@sanketvhaval6113 6 ай бұрын
What is the code for other cells?
@sanketvhaval6113
@sanketvhaval6113 6 ай бұрын
With the use of your code we can only update start time and end time only for one cell. so could you assist for other cell also?
@unsubscribedhealthcare
@unsubscribedhealthcare 6 ай бұрын
@@sanketvhaval6113so make sure that you change the cell from a2 to what cell you want to change instead. The end time example uses cell B2 and you can also change that to what ever cell you would like
@axxxer__
@axxxer__ 3 ай бұрын
Hi I have the same question, will the code be (A1-A10) ? so when I run the next start time, the time record will be posted on A2 Cell?
@k.r.j3475
@k.r.j3475 7 ай бұрын
This is EXACTLY what i was looking for! Thank you!
@unsubscribedhealthcare
@unsubscribedhealthcare 7 ай бұрын
You’re very welcome!
@sanafaheem6303
@sanafaheem6303 8 ай бұрын
These series were so cool! I can finally create a working dashboard for my patients. However I still have a few questions. I am creating a universal dashboard for all my clinics needs, which means i need patient information, their follow up visits, etc as well as an inventory of the medicines given to the patients. My question is there a way to display all entries made for a single patient? ie when i look up a patient I am able to see details of their visit such as in this video, but i want to see all the visits theyve made so far. Using the steps in these series I am able to do that only if I select the option x amount of times from the dropdown. Can this be automated to just one time selection which gives back all current and previous visits?
@unsubscribedhealthcare
@unsubscribedhealthcare 8 ай бұрын
Yes! I do this for my billing tab here is a video kzbin.info/www/bejne/aIa2iJ2craiVnsksi=o7LdAwrbB2rJqySs
@themakeinfo
@themakeinfo 8 ай бұрын
Thank you for the video. This feature is not available for everyone.
@unsubscribedhealthcare
@unsubscribedhealthcare 8 ай бұрын
This is available if you have the google workspace independent plan. It’s not available on any other plan yet.
@thisbecoleman4837
@thisbecoleman4837 8 ай бұрын
Hi Max, is there a way to adjust for insurance contract payments? Ie bill rate is $50 buy insurance pays $37.50?
@unsubscribedhealthcare
@unsubscribedhealthcare 8 ай бұрын
You will be able to edit any text or number as you like. Because this uses google sheets you can easily adjust the numbers to fit your needs.
@midwifelouisianallc44
@midwifelouisianallc44 8 ай бұрын
Thank you for the 5 part series. The Range for VLOOKUP was confusing me. I think I have a better understanding of it now. Also, the extra for cleaning it up when the value to draw from is blank is very helpful.
@unsubscribedhealthcare
@unsubscribedhealthcare 8 ай бұрын
Glad it was helpful!
@user-ug8oh9ik4i
@user-ug8oh9ik4i 8 ай бұрын
So is their whole folder available for them to see when they log into their portal? Right now I could only imagine using it for superbill maybe. I just don't want their whole file being wide open. By the way, you are brilliant and so helpful.
@unsubscribedhealthcare
@unsubscribedhealthcare 8 ай бұрын
You would make a folder available to them by clicking the share now and anyone with a link. This would be the link you place at the end. So you could make a Superbill folder for that patient and just upload the superbills there. I appreciate it! Just thinking out loud with these early videos :)
@ginathegreat3858
@ginathegreat3858 8 ай бұрын
Ugh, now the cat's out of the bag, they'll disable the mute!
@unsubscribedhealthcare
@unsubscribedhealthcare 8 ай бұрын
I hope not!
@BeepBeepParkie
@BeepBeepParkie 8 ай бұрын
The reason we're not supposed to use phones at the gas pump is because static electricity, but I'm sure those put off more static than phones do.
@unsubscribedhealthcare
@unsubscribedhealthcare 7 ай бұрын
I watched a mythbusters episode on that and they couldn’t get the gas to ignite with just the phone.
@BabyGirl_1024
@BabyGirl_1024 8 ай бұрын
Until you get to a speedway then your fucked😂😂(ive smashed every button it does nothing)
@unsubscribedhealthcare
@unsubscribedhealthcare 8 ай бұрын
I’ve stopped going to places I can’t mute :/