Excellent tutorial, just what I've been looking for. I have used Excel and VBA previously to create similar app but I need to use Google Sheets to allow access on mobile devices and have never used Apps Script. I have subscribed and look forward to the remaining tutorials in this series. Thank You.
Thank you so much every thing is so clear your explanation and presentation so great and easy and simple but unfortunately it did not work on android thanks again
Excellent tutorial, your explanation is so easy to follow and to understand, i want to thank you for sharing all your ideas about Data Entry, this is very useful.
Thank you very much for your video Dilip. Regarding the null value check on the user interface section i would suggest "getvalue" method instead of isBlank, here is the usage : if (shUserForm.getRange("C7").getValue() === "") { ui.alert("Your Message"); shUserForm.getRange("C7").activate(); shUserForm.getRange("C7").setBackground("FF0000"); return false; }
Apreaciable Work. I need to learn Visual Basic online. Cant afford classes. I am 50. Engineer turning into business as admin / qa/qc / quality control. Thank you for uploading more VB integrated Excel programming.
Thanks for your feedback! You can find several tutorials on UA-cam. You can visit our website too find the link of tutorials. Link is available in the description box. Thanks!
I did the same file in Excel thanks to your tutorial, and I want to share with multiple people so they can fill the info and now I found this video, you are really awesome man, thanks for the good work
Thank you for the uploading this tutorial. Catching some extent . My questions and doubts in respect of google sheets has been cleared. Thanks once again for your tremendous efforts you have made on this subject. Subscribed.
This is a brilliant form. I was looking to create a form to input my cryptocurrency transactions. I want to be able to enter the data without having to scroll through hundreds of entries just to be able to find a spot to enter new data. Thanks for the ideas. Think the only thing that could improve on this is if you did a pop up entry form.
Thanks for this Video you are really dedicated enough to teach us your Knowledge about Automated Data Entry for Beginners Like us I have watch your video and what I learn here is better than in school I wish all my Teachers are Like you when it comes to this OUR SCHOOL NEVER TEACH US THIS THING so I's clueless that DATA ENTRY is important to make things more efficient in Excel ONCE AGAIN THANK YOU FOR THIS TUTORIAL HOPE YOU GAIN MORE SUBSCRIBERS AND VIEWS
This is very good and clear instruction BUT does this data entry form work outside of sheets? Can you publish the sheet to the web and keep the data sheet separate?
Dear Data Labs team It was wonderful Video regarding the automated data entry sheet on UA-cam and appreciate your effort to make some videos for common people. Since coding is all together is new subject for me so if you can help my business to develop some google sheet formats related to my business. You may Connect me with your offer undersigned with detailed information.
Hello Sir .... Hope you are doing well... I am very much thankful to you on sharing such tutorial with us... It is a great help to my company project... I have zero knowledge in JS coding... But after watching your video I am able to write code... Thank you for that.... Sir could you make a tutorial video in this Google Form series about Dynamic Dependable drop down list (single level and multi level). Date of last entry of the customer (person) in search option... Please sir... 🙏🙏🙏 Also the way you explaining things is really remarkable.... So could you please make a complete tutorial series of videos from Beginner level to Expert level for Google App Script.... Please.... If you are providing any online class then please let me know... I would like to join that as well... Thank you Sir....
Thank you very much!! This is very helpful for saving many contacts. But I have a problem when I'm looking for a contact that I only remember his/her institution, instead of his/her name. Please teach me how to expand the search function, in order I can find a list of several contacts with the same category, instead of only 1 contact. Thank you again!!!
Thanks the datalabs for the knowledge but I need help for the vba code of delete all data record which is already stored and to call the number of last entry data
If this form is shared to 100 people and they work at a time it can not work. And there is no restriction of duplicate entry. Would you like to suggest ?
bro ur stuff is amazing...i have a clothing shop...i want to fill all inventory in excel and give the products code...also record the sale with the cost...i have womens, mens clothes and shoes also other things....can you help me out?
About question. if the form already exist all I need to do really is to automate the data entry part. The data is in excel or Google sheet Appreciate your feed back
Hi When i clicked on the save and the script is running and showing as finished script but the data is not saved to database could you please suggest that
Thank you so much for this tutorial, your explanation is super clear. I have a question though; is this something that other users that have access to edit the spreadsheet can use? Or only the owner of the google script can use it?
Hi @TheDataLabs team - I have followed the entire series and really appreciate the work that has been done on it. I'm able to do all the steps and apart from Submit button, everything else is working as expected. Can you please help me on - after clicking on Submit button data is not being stored in the database sheet although I have declared the variable as you said?
In my Database Sheet, I have columns that are formulated based from another column. For example, "Age" Column has age formula based on the Birthdate Column. The Birthdate Column is a data to be inputed from the form, but not the age. How can we skip the Age Column when the new data is saved from the form to the Database Sheet? :)
I tried making similar sheet with clear and submit button the sheet works fine in laptop but its not working in mobile device . Is there any way I can make it work in mobile device also?
Thank you man. I am building an excel sheet to manage the costings of my father's agri farm, and this is exactly what I was looking for
you created by seeing this just only tutorial?
Really you are a BEST teacher who explain every step in easy mode. Thanks for your Video.Please UPLOAD second Part...
Thanks for your appreciation! Second part has been already uploaded. Will update third part of this series ASAP. Thanks!
Excellent tutorial, just what I've been looking for. I have used Excel and VBA previously to create similar app but I need to use Google Sheets to allow access on mobile devices and have never used Apps Script. I have subscribed and look forward to the remaining tutorials in this series. Thank You.
Thanks for your feedback!
@@thedatalabs sir can you make tutorial make drop down for save data with android phone.. tanks!!
can this work on mobile
@@abuomardontadd2865we can see and entry data... But can't run the scripts
Very useful! This uses a lot of common functions needed in any data entry-related project, thanks so much for the clear demonstration!
What an explanation everything clearly explained. Be it drag and drop or coding everything went smooth. Please upload the 2nd part asap.
WOW !!! there was only one good channel on google scripting .. , & this one of such good quality is from India !!!
Thanks for your feedback!
This was excellent. Thanks a lot for such nice tutorial. Thank you so much for the hardwork done
Thanks for your appreciation!
Thank you so much every thing is so clear your explanation and presentation so great and easy and simple but unfortunately it did not work on android thanks again
Nice, How to avoid duplication of entry here? Please make a video on it. it will be helpful to avoid same entry of data
TO EVERYONE STRUGGLING WITH submitData button errors. REFRESH the excel/sheet tab and that's what made it work for me :D
THANK YOU!
It still didn't work for me. :(
just started and already i know this tutorial will assist me in so many ways Quyanaq!
Excellent tutorial, your explanation is so easy to follow and to understand, i want to thank you for sharing all your ideas about Data Entry, this is very useful.
Thank you very much for your video Dilip. Regarding the null value check on the user interface section i would suggest "getvalue" method instead of isBlank, here is the usage : if (shUserForm.getRange("C7").getValue() === "") {
ui.alert("Your Message");
shUserForm.getRange("C7").activate();
shUserForm.getRange("C7").setBackground("FF0000");
return false;
}
Apreaciable Work. I need to learn Visual Basic online. Cant afford classes. I am 50. Engineer turning into business as admin / qa/qc / quality control.
Thank you for uploading more VB integrated Excel programming.
Thanks for your feedback! You can find several tutorials on UA-cam. You can visit our website too find the link of tutorials. Link is available in the description box. Thanks!
thanks a lot your very clear and neat explanations with very supporting documents.
I did the same file in Excel thanks to your tutorial, and I want to share with multiple people so they can fill the info and now I found this video, you are really awesome man, thanks for the good work
how ?!!
@@chevapr thanks for replying 🥺
@@lionFTW no problem, if you need any help let me know
@@chevapr probably i will. But i’ll try first. 🙏🏻
Thank you for the uploading this tutorial. Catching some extent . My questions and doubts in respect of google sheets has been cleared. Thanks once again for your tremendous efforts you have made on this subject. Subscribed.
You deserve subscriber ,
This is a brilliant form. I was looking to create a form to input my cryptocurrency transactions. I want to be able to enter the data without having to scroll through hundreds of entries just to be able to find a spot to enter new data. Thanks for the ideas. Think the only thing that could improve on this is if you did a pop up entry form.
this is a brilliant idea!
Good sir
Dapatkan di gunakankan secara bersamaan dgn 2 pengguna atau lebih tq
Excellent .
Super usefull and clear explanation with a code. Thanks for this
Great Work.
It will solve a major problem
Thanks, i"ll try
Thank you so much for the wonderful tutorials.
Your demonstration is so easy to follow for a newbie like me! Kudos!
Amazing sharing👍👍
Thanx a million bro. Your video helps me lots!
Hi this is really amazing thank you
May I also ask on how to avoid duplicate data after clicking the button (submitData)
clear explanation...thank you
thanks for this video
Thanks so much, very pratical
This tutorial was so useful and had lots of learnings even I don't have a background in coding.
I want to learn about code. Hope you can help me.
👍👍👍👍👍👍👍👍👍👌👌👌👌👌👌👌👌👌 very very excellent script, Thanks Sir
Woa, This video helpful for me, Thanks you so much
thanks brother
Thanks for this Video you are really dedicated enough to teach us your Knowledge about Automated Data Entry for Beginners Like us I have watch your video and what I learn here is better than in school I wish all my Teachers are Like you when it comes to this OUR SCHOOL NEVER TEACH US THIS THING so I's clueless that DATA ENTRY is important to make things more efficient in Excel ONCE AGAIN THANK YOU FOR THIS TUTORIAL HOPE YOU GAIN MORE SUBSCRIBERS AND VIEWS
Hi Dilip, thanks for informative video. Is it possible for multiple people to use same form at the same time ?
OMG I made it! thanks a lot.
Very useful. Thank you sir!
Thank you for creating a very helpful and easy to follow video! Great job!!! :) :) :)
👍👍
Clearly explained
Hat's off
Thank you!
good , saudi riyad.
Thanks for your feedback!
Nice one. Thanks for the tutorial TDL
This is very good and clear instruction BUT does this data entry form work outside of sheets? Can you publish the sheet to the web and keep the data sheet separate?
Dear Data Labs team
It was wonderful Video regarding the automated data entry sheet on UA-cam and appreciate your effort to make some videos for common people.
Since coding is all together is new subject for me so if you can help my business to develop some google sheet formats related to my business.
You may Connect me with your offer undersigned with detailed information.
recording the macro and use that in the form can save huge coding .....
Thanks
This is very useful thank you so much. Very easy to follow 👌
Very very nice Sir thank you 🙏🙏🙏
nice sir..
Can it use with excel online office scripts , I mean that the scripts ( language) in google sheet same as with excel online ( Office script) or not ?
please upload the script for my our reference.. Very useful to start with.. Thank you so much for this video..
Thanks mate very good and explanatory video, keep the good work.
Flawless tutorial. Awesome!
Glad you liked it!
Great video . Liked the simplicity
Hello Sir ....
Hope you are doing well...
I am very much thankful to you on sharing such tutorial with us... It is a great help to my company project... I have zero knowledge in JS coding... But after watching your video I am able to write code... Thank you for that....
Sir could you make a tutorial video in this Google Form series about Dynamic Dependable drop down list (single level and multi level).
Date of last entry of the customer (person) in search option...
Please sir... 🙏🙏🙏
Also the way you explaining things is really remarkable.... So could you please make a complete tutorial series of videos from Beginner level to Expert level for Google App Script.... Please....
If you are providing any online class then please let me know... I would like to join that as well... Thank you Sir....
Thank you so much for this amazing tutorial!
Is there anyway to avoid duplication of entry using app script?
thankyou so much!!!! this is amazing
thanks
thank you for this video
im learning so much ...... thank u for the useful videos ........ any tutorial about sql and cloud network data apps? all the best to u
Thanks for the video.
THAK YOU SO MUCH
Thank you so much for this, very useful on my project. May I also know how to search from 2 spreadsheet using 1 userform? thanks
thank you very much
can i click save button directly after input the address, without clicking on other cell?
This is amazingly explained!!!!
Thank you very much!! This is very helpful for saving many contacts. But I have a problem when I'm looking for a contact that I only remember his/her institution, instead of his/her name. Please teach me how to expand the search function, in order I can find a list of several contacts with the same category, instead of only 1 contact.
Thank you again!!!
Sir, how to print like from specific id number to specific id number at the database record? I mean using apps script..
It was amezing!
If I wish this form to hide at a fix time of a day and show again at a fix time next day autometicaly, how to do it ? Please
Possible problem in your script is that it allows multiple use of Employee ID. Which should be unique
great!
Thanks the datalabs for the knowledge but I need help for the vba code of delete all data record which is already stored and to call the number of last entry data
If this form is shared to 100 people and they work at a time it can not work. And there is no restriction of duplicate entry. Would you like to suggest ?
bro ur stuff is amazing...i have a clothing shop...i want to fill all inventory in excel and give the products code...also record the sale with the cost...i have womens, mens clothes and shoes also other things....can you help me out?
please do how to create the different sheets and different user forms simultaneously in one worksheet in the VBA Excel
this is tutorial helped me a lot! i have a question. can it be used by multiple users simultaneously?
Very useful, i did it successful in the computer. but i wonder if we can run script in the phone or tab? Thank you so much!
good
hello, do you know api connector?
do you use AI for coding?
can I find "templates" ?
thanks
Thanks for nice tutorial.. i need tutorial crud userform VBA Crud database googlesheet. Thanks before
great tutorial and very helppol video
About question. if the form already exist all I need to do really is to automate the data entry part. The data is in excel or Google sheet Appreciate your feed back
Very informatively done. Many thanks.
BTW, can we use this form to enter data by multiple users at the same time?
Up to this. I would like to know also, if users can user the form simultaneously?
up to this. i would also like to know if this is valid for multiple users.
Can you also teach how to prepare REPORT ?
Hi When i clicked on the save and the script is running and showing as finished script but the data is not saved to database could you please suggest that
Thank you so much for this tutorial, your explanation is super clear. I have a question though; is this something that other users that have access to edit the spreadsheet can use? Or only the owner of the google script can use it?
Thanks for the tutorial. Very useful. A proposal for the next video, please make the recording with slightly bigger font! Continue the Good Work!
Thanks for your feedback!
sir, how to make this field can be inserted into another sheet? (not in the same sheet)
Good evening, how to publish the table and table on the site so that the site users can make changes to the table and their table?
What if, I need to keep Database and User Form in 2 different files ? I dont want all users to access the database sheet?
sir, can you make a tutorial on this data connection to the web app so that it can be more realtime. thank you
Nice One, Amazing Job
Hi @TheDataLabs team - I have followed the entire series and really appreciate the work that has been done on it. I'm able to do all the steps and apart from Submit button, everything else is working as expected.
Can you please help me on - after clicking on Submit button data is not being stored in the database sheet although I have declared the variable as you said?
same tho
You guys are doing wonderful job. Easy and understandable explanation. Hits on like button and subscribed for next booming
thank u for the tutorial and i followed alone but the code dont yield any input..... any tips to solve this problem
In my Database Sheet, I have columns that are formulated based from another column. For example, "Age" Column has age formula based on the Birthdate Column. The Birthdate Column is a data to be inputed from the form, but not the age. How can we skip the Age Column when the new data is saved from the form to the Database Sheet? :)
I tried making similar sheet with clear and submit button the sheet works fine in laptop but its not working in mobile device . Is there any way I can make it work in mobile device also?