I checked at mentioned time nothing changed. Google form id and question IDs are same. Follow steps and try yourself. Definitely work. Can you please send me both screenshot before and after on email id mentioned in about section. Thank you 😊
This video was great ! I have question that how can we track the absent of Employee and how can we integrate it with salary slip ? is it possible to do that ? do you have any video on it Sir?
Hello Sami. I have created a Cash Advance Form for our office, I am just wondering how can I integrate it to our salary slip? Looking forward to your response. Thank you.
HI SIR ...FIRST THANK YOU FOR VIDEO ...NEXT IF EMPLOYEE SCANINING THE OTHER EMPLOYEE HOW CAN I KNOW ...... HAVE SOULTION TO TAKE IME FOR MOBILE OR OTHER KODE FOR MOBILE
Hi but bro ..if someone snap pic of QR code he can mark his attendance at his will ..he may not be at office? Is there a way where we can program this only via scan mode and not from gallery?
As per my knowledge you can two ways for this. One is PC/Mobile around office entry to scan QR which is shared with Employee which is pay for PC/Mobile Cost. Another is GPS/Location Tracker method in Google Form which is created with GAS. Thank You.
सबसे पहले आपका बहुत-बहुत धन्यवाद। काफी इनफॉर्मेटिव वीडियो है। लेकिन यहां मैं यह जानना चाहता हूं के के कोई भी एंप्लोई किसी दूसरे एंप्लॉई के बार कोड को स्कैन कर सकता तो हम यह कैसे पता करें की सही बंदे ने अटेंडेंस मार्क की है।
agar office me attendance system hai to camera use karsakte hai but google form me option nhi hai other formbuilder ka use karna hoga. like jotform. agar remote(ghar) se attendance system hai to apps script ke saath me google map ka use karsakte hai Thank you.
How can we automate the QR codes through out the whole column? Please suggest any formula to generate qr code automatically without dragging downwards. 🙏
This is really amazing way. I was not aware of the fact that excel sheet can be of this much useful!. Thank you for this amazing video Btw, i am curios to know about the codes use there
You can add Questions in Google Form for Check IN & OUT and Separate Coloumn ke liye data me formula use karke bhi karsakte hai. Google Form ke Question ke Answer form submit ke baad confirmation message me ajaye uske liye apps script se karsakte hai. Kosish karunga video banane ki. Stay tuned. Thank you
If your link is correct then setting issue in your QR/Bar code scanner settings. Please enable automatically open URLs options in your QR code scanner app. Thank you.
सर आपका विडियो बहुत ही ज्यादा impressive है। आपसे अनुरोध है कि गुगल फॉर्म में स्टूडेंट/इंपलोई अटेंडेंस शीट को QR Code के साथ इस तरह से डिजाइन कीजिये कि वह लाइव लोकेसन ट्रेक करने के साथ ही फॉर्म सबमिट करने वाले का पिक्चर भी क्लिक करे, और हर दिन ऑटोमैटिक उसके नाम का QR Code अपडेट (चेंज) होता रहे।
Thank you for your comment and suggestion. Google Apps script Series abhi abhi start hua hai aanewaale dono me new interesting videos milenge live location ke saath me attendance aur iske alawa bahut kuch. Thank you.
bro agar is kisi aur ke QR code ko koi bhi scan krta rhega to kisi aur ki attendance lag jayegi . kuchh esa btaao ki jisme main scan kru to meri hi attendance lge na ki kisi aur ki . Suppose mera name Amit hai lekin main Pawan Singh ka QR code scan kruga to URL to fir bhi hit ho jayega and response add ho jayega. I think this is not perfect solution for QR attendance
Kahi na kahi kuch error hoga. Please Check. Phir bhi nhi horha hoga to google sheets share kardijiye, About Section me email ID hai uss email id par. Thank You
🎉🎉🎉🎉superb useful🎉
Amazing. It is working 100% successfully. Thanks TPT ❤
Welcome 👍
Isms candidat ki photo bhi lga sakte h kya
Great video every minor things explained thanks you 👍
Glad it was helpful! 🙂
Sir i have doubt that in 5:57 u selected & the formula.got erased or u pressed any button and pasted another link
I checked at mentioned time nothing changed. Google form id and question IDs are same.
Follow steps and try yourself. Definitely work.
Can you please send me both screenshot before and after on email id mentioned in about section.
Thank you 😊
Sir, can you help me, how would I use one QR code for staff in and out . And I want date time in different columns
Excellent!!
Thank you! Cheers!
@@TenPowerTen How to i will Download this QR code as image/JPEG file?
We need only 24 hours of One QR card will be scan but no need same ID card scan in 24 hours, You have any suggestion sir?
Excellent 🙏
Thank you! Cheers!
good work
Thank you! Cheers!
Increíble aporte, muchas gracias, aprendí mucho y lo utilizare en un proyecto para mi empresa, tienes un like y suscripción más bro.
Muchas gracias hermano.
This video was great ! I have question that how can we track the absent of Employee and how can we integrate it with salary slip ? is it possible to do that ? do you have any video on it Sir?
Hello Sami. I have created a Cash Advance Form for our office, I am just wondering how can I integrate it to our salary slip? Looking forward to your response. Thank you.
is there any software can we integrate with barcode reader system?
very nice but can we use it to for example book in product one sheet and book out product on other sheet
Yes you can
Thank you.
@@TenPowerTenHow sir
Bohot gajab bhai
Thank you so much bro.
Thank you.
how can we make it for check in and check out both for the same day attendance?
HI SIR ...FIRST THANK YOU FOR VIDEO ...NEXT IF EMPLOYEE SCANINING THE OTHER EMPLOYEE HOW CAN I KNOW ...... HAVE SOULTION TO TAKE IME FOR MOBILE OR OTHER KODE FOR MOBILE
Hi but bro ..if someone snap pic of QR code he can mark his attendance at his will ..he may not be at office? Is there a way where we can program this only via scan mode and not from gallery?
As per my knowledge you can two ways for this. One is PC/Mobile around office entry to scan QR which is shared with Employee which is pay for PC/Mobile Cost. Another is GPS/Location Tracker method in Google Form which is created with GAS.
Thank You.
सबसे पहले आपका बहुत-बहुत धन्यवाद। काफी इनफॉर्मेटिव वीडियो है।
लेकिन यहां मैं यह जानना चाहता हूं के के कोई भी एंप्लोई किसी दूसरे एंप्लॉई के बार कोड को स्कैन कर सकता तो हम यह कैसे पता करें की सही बंदे ने अटेंडेंस मार्क की है।
agar office me attendance system hai to camera use karsakte hai but google form me option nhi hai other formbuilder ka use karna hoga. like jotform.
agar remote(ghar) se attendance system hai to apps script ke saath me google map ka use karsakte hai
Thank you.
Sir can we track the location of the person who is scanning the QR CODE so that no one can scan the QR from his home.
Thanks
Yes we can track it
Excellent
Thank you so much 😀
Sir esame koi bhi kisi ka qr scan krk attendance de sakta hai
Super🎉
Glad it helped.
Thank you. 👍
Can we make a monthly report instead of daily report ? Like in a monthly report daily attendance could be generated ?
Yes, From Database (Response Sheet), easily make daily/Weekly/Monthly/Yearly Reports etc. In this video Report Generation is not included.
Thank You
@@TenPowerTen Than pls make a video in which it is included. & generated automaticaly 🙏.
Thanx & nice video.
Please sir please make a video for monthly report
Sir kya same process ko bar code se kar sakte hai instead of QR code.
Kyu r code se first hota hai isiliye
When i submit form by mobile barcode, the borderline in good sheet disappears. Please explain if anyone know About it.
What a cool video! Thank you for your effort and I like how you explained it so simply. How can we create the check out function ? Via another form ?
Glad it was helpful!
Great suggestion!
How can we automate the QR codes through out the whole column?
Please suggest any formula to generate qr code automatically without dragging downwards. 🙏
Hello sir, Can we add Location ? so if anyone will scan so there scan location we can see?
Yes with Google Apps script.
Really appreciated.
Glad to hear that.
Thank You.
This is really amazing way. I was not aware of the fact that excel sheet can be of this much useful!. Thank you for this amazing video
Btw, i am curios to know about the codes use there
Glad it was helpful!
Thank you for your lovely comment.
Hii can I use for my school attendance reply plz
Yes you can try.
Thank you.
Sir aisa option jisme scan ke baad check in or check out then submit or check in ka time alag column me aaye or check out ka alag column me
You can add Questions in Google Form for Check IN & OUT and Separate Coloumn ke liye data me formula use karke bhi karsakte hai.
Google Form ke Question ke Answer form submit ke baad confirmation message me ajaye uske liye apps script se karsakte hai. Kosish karunga video banane ki.
Stay tuned.
Thank you
thank you so much bro
Always welcome
Thks Sir, how I can change Welcome ..... after scanning Qr Code
, thank u sir.....
Most welcome.
Bhai employee Ghar se scan kr dega to ??
Hello sir 10 name ek sath entry Kara chahe to
When I try to scan QR code it shows only link instead final submission..kindly reply.
If your link is correct then setting issue in your QR/Bar code scanner settings.
Please enable automatically open URLs options in your QR code scanner app.
Thank you.
सर आपका विडियो बहुत ही ज्यादा impressive है। आपसे अनुरोध है कि गुगल फॉर्म में स्टूडेंट/इंपलोई अटेंडेंस शीट को QR Code के साथ इस तरह से डिजाइन कीजिये कि वह लाइव लोकेसन ट्रेक करने के साथ ही फॉर्म सबमिट करने वाले का पिक्चर भी क्लिक करे, और हर दिन ऑटोमैटिक उसके नाम का QR Code अपडेट (चेंज) होता रहे।
Thank you for your comment and suggestion.
Google Apps script Series abhi abhi start hua hai aanewaale dono me new interesting videos milenge live location ke saath me attendance aur iske alawa bahut kuch.
Thank you.
bro agar is kisi aur ke QR code ko koi bhi scan krta rhega to kisi aur ki attendance lag jayegi . kuchh esa btaao ki jisme main scan kru to meri hi attendance lge na ki kisi aur ki .
Suppose mera name Amit hai lekin main Pawan Singh ka QR code scan kruga to URL to fir bhi hit ho jayega and response add ho jayega. I think this is not perfect solution for QR attendance
I have successfully created but how we automate time & out time according to timestamps.
please help sir
Sir mene apke diye hue process ko step by step follow kiya pr phir bhi end me scan krne pr ( Sorry,unable to open these file) aisa likh ke aa raha hai
Kahi na kahi kuch error hoga. Please Check. Phir bhi nhi horha hoga to google sheets share kardijiye, About Section me email ID hai uss email id par.
Thank You
@@TenPowerTen sir email id show nhi kr raha hai about me
Aap mujhe reply me de dijiye na email id
@@TenPowerTen sir ky apka contact no. Mil sakta hai
Vo sheet regarding baat karni thi
@@TenPowerTen sir mera dead line date najdik aa gaya hai
@@TenPowerTen help me
BARCODE NOT CREATE PLEASE HELP
please provide a source file and please explain step by step
I have qr code base attendance system
This would be helpful if it is in English
Video best hai but In time hi enter hi raha hai but out time k liye kya kare ????
Genial
Its not working. Pls send me solution.
esa ho sakta hai ek bar code ho , sab scan kare and hum sare logo ka attendance le sake
Ky kru sir
agar kisi ne ghar se hi kr dea to
Please answer this. Is there any solution to it.
कुछ नही समझ आ रहा है
What to do if after scanning QR code its directing to form link instead of submiiting the fomr? can anyone help