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.
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 RUclips. 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
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.
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
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.
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
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.
Thank you for the tutorial. Does the Data sheet & the entry form need to be in the same spreadsheet, or can you reference the data sheet in the same google drive?
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?
Dear Data Labs team It was wonderful Video regarding the automated data entry sheet on RUclips 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!!!
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 brother. Its really amazing. This will definitely aid small scale business for record maintenance. Please suggest can we edit this google sheet on mobile also? because i wanted to maintain records with mobile phone in Google sheet. I have prepared a form but not able to edit this form on mobile. Pls suggest any solution.. Thanks once again...
Thanks for your feedback! I am not sure about development on mobile but you can use it on mobile or any platform as it's browser based solution. Thanks!
@@thedatalabs yes I can use it on mobile but Google sheet is not working smoothly on mobile as compared with pc or laptop..so using this sheet on pc or laptop is the best way.. Thanks..
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; }
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? :)
Amazing video....Something I have been looking for so long. Just a quick question....is it possible to create a centralized database where if multiple users are working on the database then all of their data is saved in some centralized sheet??
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
Hello, is there a way we can assign a script, like a Save button? Once we hit Save it will be imported to another google sheet not only on the same sheet?
Thank you! This is a very detailed tutorial with easy-to-follow instructions. However, why am I getting "TypeError: ui.alert is not a function" when I tried to save an entry in the form?
Hi all, I would like that by pressing the "tab" key the active cell moves between the fields to be filled in without using the mouse. Is it possible to achieve this?
![How to create a data entry form in Google Sheets [with multiple databases]](http://i.ytimg.com/vi/qo743XZOU0M/mqdefault.jpg)
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
WOW !!! there was only one good channel on google scripting .. , & this one of such good quality is from India !!!
Thanks for your feedback!
What an explanation everything clearly explained. Be it drag and drop or coding everything went smooth. Please upload the 2nd part asap.
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 RUclips. You can visit our website too find the link of tutorials. Link is available in the description box. Thanks!
Very useful! This uses a lot of common functions needed in any data entry-related project, thanks so much for the clear demonstration!
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. :(
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. 🙏🏻
just started and already i know this tutorial will assist me in so many ways Quyanaq!
This was excellent. Thanks a lot for such nice tutorial. Thank you so much for the hardwork done
Thanks for your appreciation!
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.
You deserve subscriber ,
Great Work.
It will solve a major problem
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
Nice one. Thanks for the tutorial TDL
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.
Super usefull and clear explanation with a code. Thanks for this
Your demonstration is so easy to follow for a newbie like me! Kudos!
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
👍👍
Clearly explained
Hat's off
thanks a lot your very clear and neat explanations with very supporting documents.
OMG I made it! thanks a lot.
Thanx a million bro. Your video helps me lots!
Excellent .
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!
Flawless tutorial. Awesome!
Glad you liked it!
Thank you so much for the wonderful tutorials.
clear explanation...thank you
👍👍👍👍👍👍👍👍👍👌👌👌👌👌👌👌👌👌 very very excellent script, Thanks Sir
Very useful. Thank you sir!
Great video . Liked the simplicity
please upload the script for my our reference.. Very useful to start with.. Thank you so much for this video..
Thanks so much, very pratical
Thanks mate very good and explanatory video, keep the good work.
Nice One, Amazing Job
Thank you for creating a very helpful and easy to follow video! Great job!!! :) :) :)
thankyou so much!!!! this is amazing
Hi Dilip, thanks for informative video. Is it possible for multiple people to use same form at the same time ?
Good sir
Dapatkan di gunakankan secara bersamaan dgn 2 pengguna atau lebih tq
This is very useful thank you so much. Very easy to follow 👌
This is amazingly explained!!!!
Amazing sharing👍👍
Very very nice Sir thank you 🙏🙏🙏
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 ?
im learning so much ...... thank u for the useful videos ........ any tutorial about sql and cloud network data apps? all the best to u
Thank you so much for this amazing tutorial!
Is there anyway to avoid duplication of entry using app script?
You guys are doing wonderful job. Easy and understandable explanation. Hits on like button and subscribed for next booming
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.
Thanks for the video.
Nice, How to avoid duplication of entry here? Please make a video on it. it will be helpful to avoid same entry of data
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!
Thank you for the tutorial. Does the Data sheet & the entry form need to be in the same spreadsheet, or can you reference the data sheet in the same google drive?
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
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
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!
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.
Dear Data Labs team
It was wonderful Video regarding the automated data entry sheet on RUclips 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.
Woa, This video helpful for me, Thanks you so much
Thanks, i"ll try
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....
great tutorial and very helppol video
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
Love to u brother 😘
please do how to create the different sheets and different user forms simultaneously in one worksheet in the VBA Excel
sir what video recording and editing tool did you use? Please?
this is tutorial helped me a lot! i have a question. can it be used by multiple users simultaneously?
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 for nice tutorial.. i need tutorial crud userform VBA Crud database googlesheet. Thanks before
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?
great video and thank you
Thanks!
Thanks brother. Its really amazing. This will definitely aid small scale business for record maintenance.
Please suggest can we edit this google sheet on mobile also? because i wanted to maintain records with mobile phone in Google sheet. I have prepared a form but not able to edit this form on mobile. Pls suggest any solution..
Thanks once again...
Thanks for your feedback! I am not sure about development on mobile but you can use it on mobile or any platform as it's browser based solution. Thanks!
@@thedatalabs yes I can use it on mobile but Google sheet is not working smoothly on mobile as compared with pc or laptop..so using this sheet on pc or laptop is the best way.. Thanks..
Thank you!
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;
}
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? :)
sir, how to make this field can be inserted into another sheet? (not in the same sheet)
Amazing video....Something I have been looking for so long. Just a quick question....is it possible to create a centralized database where if multiple users are working on the database then all of their data is saved in some centralized sheet??
thanks for this video
Sir, how to print like from specific id number to specific id number at the database record? I mean using apps script..
recording the macro and use that in the form can save huge coding .....
Hi this is really amazing thank you
May I also ask on how to avoid duplicate data after clicking the button (submitData)
Nice, I love this.
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?
Hey there! I There is no Script editor in my google spreadsheet. any help? Thank you..
Awesome work by the way!
Excellent ! This is what I was looking for, but I am hoping for a tutorial on how multiple users from mobile device can enter data through this form.
for mobile it might be easier to do it with google forms
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
This form is very informative, thanks. Just got one question in PC it works fine but in android buttons are not working, any clue?
Can you design same form for mobile?
Can we use Google App script on Google Sheet Mobile App?
Well done!
Hi, this is possible to add the info to other document instead of other sheet ?
Thank you very much!!! Can you pls advise how can use this form multiple users in a time.. awaiting your valuable reply plzzzz 🙏🙏🙏
Can you also teach how to prepare REPORT ?
I have a question, please reply, Can this type of Forms be used for taking attendance purpose of Employees??
Yes, you can develop a form with same logic to capture employees attendance. Thanks!
@@thedatalabs Would you like to do a program on it?
Hello, is there a way we can assign a script, like a Save button? Once we hit Save it will be imported to another google sheet not only on the same sheet?
Nice Work
can i click save button directly after input the address, without clicking on other cell?
thank you very much
Thank you! This is a very detailed tutorial with easy-to-follow instructions. However, why am I getting "TypeError: ui.alert is not a function" when I tried to save an entry in the form?
Can i send it to my staff to update the list at their ends.... basically not on my pc?
Hi all, I would like that by pressing the "tab" key the active cell moves between the fields to be filled in without using the mouse. Is it possible to achieve this?