Thanks for your comments You can create a separate database and save your data after save lock all cell. Using app script for lock If I will do it then it will be chargeable
I have created similar form and want to make sure operator fill all the recod without missing. We can do it in excel using changing colour of cell using Conditional formatting and copy linked image. How we can do it in google sheet.
Sir, I want that if user forget to mandatory field how can we change the colour of submit button or suggest how we can create a error message box that "you have miss the mandatory field"
can you make a video on advance data entry for google site
Very Useful , tomorrow I will try it .😊
Amazing video, Thank you so much sir
nice video , one more thing i want to know how can we get database in seperate sheet that so user can't view or edit that data
Thanks for your comments
You can create a separate database and save your data after save lock all cell.
Using app script for lock
If I will do it then it will be chargeable
Multiple sheets me data entry kr skte h
I have created similar form and want to make sure operator fill all the recod without missing.
We can do it in excel using changing colour of cell using Conditional formatting and copy linked image.
How we can do it in google sheet.
I have explained in Google sheets not in Excel
Please watch video again
Sir, I want that if user forget to mandatory field how can we change the colour of submit button or suggest how we can create a error message box that "you have miss the mandatory field"
@Google WorkSpace Lab sir your submit button colour is not changing.
If user /operator simply click on Submit data blank record will be saved.
Sir aapne submit button kaise create Kiya hai
Insert option =>draw option
Ek sath ek se jyada log entry kar sakte he , alag alag device se ?
Copy banani padegi
Google sheet single user hoti hai
Agar Webapp ho to multiple users entry kar sakte hai
Nice ji
will it work on mobile ?
Not for mobile
Bhai practice ke liye sheet ka link do please 🙏
Would you please make same type software for collection of attendance form verious location. For me
Yes
Please mention your query on my email id
rs343560@gmail.com
Send mail to your mail please confirm me
thank you so much sir.
Nice.. valuable video.. thanks a lot
Thanks for your comments
New Google sheets
सहेजें हटाएँ संपादित करें साफ़ करें बिना स्किट कोड के यह फ़ंक्शन कैसे करें
Crud form banaye google sheet ke Liye aur athor button sheet 3 sheet 4 ,5me Jane ke liye
Helo sir, kia ham mobile se data entry ka form bana sakte hai??aor kaise??
Bilkul kar sakte hai
Google form bana lo usse entry karte jana
alt+H, V,V is not working anymore!
Is there any alternative?
Use pecial paste option
Sir apke video's bhut blur ati thodi clear video bna deya kro
Sir video ki quality sahi hai aap apni UA-cam ki setting change kar lo
Shortcuts not work in office 2021
Gjab
How to put a new entry down to the previous one? not avobe?
Thanks for your comments
You can use down arrow+ control
Then up arrow+control while you are creating macros
It will be as per your query..
Please increase volume level in video
Audio is looking good
But if you have issues with audio I will improve next video
Thanks for your comments
alt + H open the help option :(
What is this??
While typing alt+H,V,V... The help option pops out
@@SheetsGuru alt+H,V,V se Help open ho raha hai Sir... Is shortcut changed??
Use Special Option
AAP KYA BOL RAHE HO PATA NAHI CHALTA KAI SHORTCUT KAM NAHI KARTA HAI PROPER BATAIYE
How to put check in the formula?
Filter clear nahi hua
बिल्कुल समझ नही लगा। शायद आपने पहले तैयारी नही की
hello sir.... i want to make a data entry form for my video lab..... we do wedding video editing service... can i have your contact number ?