I'm creating a customer sign-in sheet and want to include a timer that starts when the customer signs in and lets me know how long they've been waiting to be seen. Perhaps an alert when they have been waiting for, say, 5 minutes, 10 minutes and 20 minutes.
Thanks for the help.
What does this sign in sheet contain?
First
Last
Mobile/Home Phone
Account Num
Street Address
City
State
Zip
Etc...?
-If you think you are done, Start over - ELeGault
The sign in sheet will ask for:
First Name
Last Name
Phone
DOB (mm/dd/yyyy)
Why you're here today:
( ) Eye appointment
( ) Pick up glasses or contacts
( ) Order glasses or frames
( ) Lab appointment
( ) adjustment to present glasses
( ) Other
Take a look at the attached files -
Save them both as they are (You can rename later, but you need to update the VBA)
The idea is that one computer will have a running "SignIn" and you will have open the "Monitor"
Throughout the day, your patience come in, they fill out the doc and punch in. You hit refresh on your pc (F9) and you will see last saved data. Then you will want to refresh frequently to keep a live check on the current patience -
You will clear out the SignIn log daily by clicking Clear log in the Monitor document.
Again, you need to have these in the same directory (Same folder)
Please take some time to run through it and try to understand what you can. When you have done so please ask questions so that I can let you know how something works if you don't know .
Almost literally sleep typing -so if there are any errors I apologize - however it appears to run just fine.
They are both Macro enabled so make sure you have them enabled when utilizing them!
SignIn.xlsm
Monitor.xlsm
g4tso- -
Just checking to see if that panned out for you. If it did, please don't forget to mark as Solved -
Thanks
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks