Automated Data Entry Form in Google Sheets & Apps Script - Part 1 (User Form Design & Transfer Code)

[@AnindoSarker]

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

[@hasanmehedi4809]

you created by seeing this just only tutorial?

[@vivekasharma3011]

Really you are a BEST teacher who explain every step in easy mode. Thanks for your Video.Please UPLOAD second Part...

[@thedatalabs]

Thanks for your appreciation! Second part has been already uploaded. Will update third part of this series ASAP. Thanks!

[@Malally2]

TO EVERYONE STRUGGLING WITH submitData button errors. REFRESH the excel/sheet tab and that's what made it work for me :D

[@mellacristobal445]

THANK YOU!

[@shadowfox1989]

It still didn't work for me. :(

[@varunsethi5662]

WOW !!! there was only one good channel on google scripting .. , & this one of such good quality is from India !!!

[@thedatalabs]

Thanks for your feedback!

[@patlynch5663]

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.

[@thedatalabs]

Thanks for your feedback!

[@prambondagangan1235]

@@thedatalabs sir can you make tutorial make drop down for save data with android phone.. tanks!!

[@abuomardontadd2865]

can this work on mobile

[@farhanbinashraf6783]

​@@abuomardontadd2865we can see and entry data... But can't run the scripts

[@ralphschraven339]

Very useful! This uses a lot of common functions needed in any data entry-related project, thanks so much for the clear demonstration!

[@abhishekpandey6803]

What an explanation everything clearly explained. Be it drag and drop or coding everything went smooth. Please upload the 2nd part asap.

[@kabijoshi5949]

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.

[@thedatalabs]

Thanks for your feedback! You can find several tutorials on KZbin. You can visit our website too find the link of tutorials. Link is available in the description box. Thanks!

[@chevapr]

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

[@lionFTW]

how ?!!

[@lionFTW]

@@chevapr thanks for replying 🥺

[@chevapr]

@@lionFTW no problem, if you need any help let me know

[@lionFTW]

@@chevapr probably i will. But i’ll try first. 🙏🏻

[@abuomardontadd2865]

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

[@mikepuno2000]

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.

[@melissagibson4364]

just started and already i know this tutorial will assist me in so many ways Quyanaq!

[@akassebaum]

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.

[@joshmack]

this is a brilliant idea!

[@zoomcam7706]

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.

[@TonyaGibbs-m6c]

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?

[@sketchstudios05]

This was excellent. Thanks a lot for such nice tutorial. Thank you so much for the hardwork done

[@thedatalabs]

Thanks for your appreciation!

[@jasperjohndegueno6760]

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

[@abrodriguez59]

please upload the script for my our reference.. Very useful to start with.. Thank you so much for this video..

[@saneerasadaruwan1103]

thanks a lot your very clear and neat explanations with very supporting documents.

[@ssharma123456]

Hi Dilip, thanks for informative video. Is it possible for multiple people to use same form at the same time ?

[@ragipgokhanergur9819]

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; }

[@donnavivu]

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!

[@pakistaniaround-amnamajeed3906]

You deserve subscriber ,

[@RichGoTech]

Super usefull and clear explanation with a code. Thanks for this

[@dyenibib]

Your demonstration is so easy to follow for a newbie like me! Kudos!

[@gangliagenghis6181]

Thanx a million bro. Your video helps me lots!

[@dr.krishanu]

Great Work. It will solve a major problem

[@FuadIhsani-lz8pp]

Good sir Dapatkan di gunakankan secara bersamaan dgn 2 pengguna atau lebih tq

[@markanthonyalipao362]

Thank you so much for this amazing tutorial! Is there anyway to avoid duplication of entry using app script?

[@mdbaitan]

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.

[@mohapatra007bisu]

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....

[@jayeshmehta4937]

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?

[@nurfatihahjunaidi1935]

same tho

[@hasithaudalagama3837]

Very informatively done. Many thanks. BTW, can we use this form to enter data by multiple users at the same time?

[@danizaperez8170]

Up to this. I would like to know also, if users can user the form simultaneously?

[@fighter12835]

up to this. i would also like to know if this is valid for multiple users.

[@angeliqueposadas9525]

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

[@Pankajkumar-yv5dr]

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

[@nanimal13]

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?

[@RoseAnn-ps8uj]

Hi this is really amazing thank you May I also ask on how to avoid duplicate data after clicking the button (submitData)

[@georgekhaba6436]

im learning so much ...... thank u for the useful videos ........ any tutorial about sql and cloud network data apps? all the best to u

[@indarkumar9083]

Nice, How to avoid duplication of entry here? Please make a video on it. it will be helpful to avoid same entry of data

[@prthakkar1972]

Dear Data Labs team It was wonderful Video regarding the automated data entry sheet on KZbin 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.

[@zunopk6894]

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 ?

[@getmegr]

👍👍 Clearly explained Hat's off

[@saurabhrai3135]

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??

[@fighter12835]

this is tutorial helped me a lot! i have a question. can it be used by multiple users simultaneously?

[@ezekielpolapen5567]

Thank you so much for the wonderful tutorials.

[@XinYue-ki3uw]

OMG I made it! thanks a lot.

[@ezmakeswa3601]

Excellent .

[@vennyroselina4299]

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!!!

[@jusatnk]

Flawless tutorial. Awesome!

[@thedatalabs]

Glad you liked it!

[@felmanjoyledesma1922]

Hey there! I There is no Script editor in my google spreadsheet. any help? Thank you.. Awesome work by the way!

[@vinendrasairamkrishna1833]

clear explanation...thank you

[@hjoseph777]

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

[@amandeepkaur5725]

👍👍👍👍👍👍👍👍👍👌👌👌👌👌👌👌👌👌 very very excellent script, Thanks Sir

[@suwaibahmohamad8743]

Very useful. Thank you sir!

[@camayurkumarparmar9227]

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...

[@thedatalabs]

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!

[@camayurkumarparmar9227]

@@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..

[@savagesick12]

sir what video recording and editing tool did you use? Please?

[@mike9230]

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?

[@freeliberalminds]

Nice one. Thanks for the tutorial TDL

[@nabazotashkheesprogramme7385]

This form is very informative, thanks. Just got one question in PC it works fine but in android buttons are not working, any clue?

[@tranvietcuong1213]

Thanks so much, very pratical

[@tividadsagriculturalproduct]

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?

[@apostoloskolovos9815]

Thanks mate very good and explanatory video, keep the good work.

[@Bhutai1981]

Great video . Liked the simplicity

[@jazzys7061]

thankyou so much!!!! this is amazing

[@fahimreza1377]

recording the macro and use that in the form can save huge coding .....

[@KaiRoulette.]

Sir, how to print like from specific id number to specific id number at the database record? I mean using apps script..

[@m.asifhussain1730]

Can you design same form for mobile? Can we use Google App script on Google Sheet Mobile App?

[@abdirahmanmuhammed9741]

please do how to create the different sheets and different user forms simultaneously in one worksheet in the VBA Excel

[@brilliantpy]

Thank you for creating a very helpful and easy to follow video! Great job!!! :) :) :)

[@latestphilnews]

Possible problem in your script is that it allows multiple use of Employee ID. Which should be unique

[@DigitalSimba]

Thanks for the tutorial. Very useful. A proposal for the next video, please make the recording with slightly bigger font! Continue the Good Work!

[@thedatalabs]

Thanks for your feedback!

[@cgwceisnemrc]

nice tutorial sir...... can i make a request? can you make code for preventing duplicate data entry to database sheet. Hoping for your response thank you

[@ryanduy]

Thanks a lot. It's great. Can I customize form with input data to column? And ui.alert with row, no one cell in that row is blank? Example: Multi Row Employee ID, Employee Name...

[@jicbro35]

Thank you very much!!! Can you pls advise how can use this form multiple users in a time.. awaiting your valuable reply plzzzz 🙏🙏🙏

[@thangarajchandra1275]

Very nice. But how to insert image in form, and cell?

[@ruangbelajarkuclub]

Thanks for nice tutorial.. i need tutorial crud userform VBA Crud database googlesheet. Thanks before

[@harkesh_rubber]

Very nice form. I have been using this form but I am not able to fill the form on a mobile device or tablet. as the button is not clickable. is there any option to submit the scripted form through mobile?

[@koladeleben]

Very helpful. How to insert the data into another workbook ?

[@secondsonchanel2220]

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

[@jelajahsebanten]

Amazing sharing👍👍

[@sonjabaria4324]

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? :)

[@CIROALABRESE]

Hi, this is possible to add the info to other document instead of other sheet ?

[@wowik1992]

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?

[@abdulazizmamify]

Hello thanks for the tutorial , I have a question how we can check the data duplication before when save the data . for example how can we can the employee id if its exists before we insert it to the database

[@Syed2]

I have a question, please reply, Can this type of Forms be used for taking attendance purpose of Employees??

[@thedatalabs]

Yes, you can develop a form with same logic to capture employees attendance. Thanks!

[@Syed2]

@@thedatalabs Would you like to do a program on it?

[@selvarajandiappa3143]

Excellent work sir.. Can you help me set up a form if I provide the data

[@ttfrhoncho6716]

How would one send data to a different tab based on one or, really two sections that were made in the input sheet ? Say the second and third field ? If this field equals this and the second field equals this, then the data would send the data to a specific tab. New to this entirely, and am guessing it will be an entirely different function that would have to consume the entry and then process it. This is a great tutorial, by the way. You explain what you are writing is doing really well. So, I'm now researching, how to, after the data has been added to the main sheet, to have it automatically move to the tabs I want it separated to. I'm wondering if that can be done with just conditional formatting? Or if there should be a button function script created to do that. Something along the lines of:

[@ttfrhoncho6716]

function onEdit(e) { const sh=e.range.getSheet(); if(sh.getName()=="sheet 1" && e.range.columnStart==1 && e.value=="TRUE") { const tsh=e.source.getSheetByName('Sheet 2'); const nr=tsh.getLastRow()+1; sh.getRange(e.range.rowStart,2,1,1).copyTo(tsh.getRange(nr,2,1,1)); sh.getRange(e.range.rowStart,4,1,1).copyTo(tsh.getRange(nr,4,1,1)); sh.getRange('E3:E').copyTo(tsh.getRange(nr,11,1,1)); } }

[@caleb941]

This is very useful thank you so much. Very easy to follow 👌

[@jjcsaba7250]

Thank you!

[@kthlnmbr]

thanks, but by the way how can I put the the userform gsheet to a website like wix? How can I use this interactively? Hope you can answer my question Thanks in advance

[@Talha9One]

good job how can find if any duplicate entry the will inform if any employee id # issue ?

[@rajesvermajal]

Very useful and it is brilliant. I have got an error at Line number 23. ui.alert is not a function it says. Please help.

[@thomasanders1954]

sir, how to make this field can be inserted into another sheet? (not in the same sheet)

[@MohammadaAprilianto]

can i click save button directly after input the address, without clicking on other cell?

[@shilpipoddar5313]

Can you also teach how to prepare REPORT ?

[@AmazedExcel]

Excellent Bro . But I Have a problem if you can solved, I'm working on Google form and get data form it. And with in a same sheet where the data of responses. I'm add a message dynamic column..and it's get data from other columns and make message dynamicly.. But the problem I'm faced, when ever a new response record it can't follow my dynamic message formula... Can you help out me. ???

[@starbob9703]

THAK YOU SO MUCH

[@ruwanleelananda2881]

Thanks, i"ll try

[@mrrmminhaj]

Sir thank you very much for your use full video. But do this tutorial for the same way but when the save button press on the User Form it will come error massage like ( TypeError:Cannot read property 'getRange' of null) how I fixed this problem??? Pls help me

[@marcnuninger3310]

Hello, your tutorial really helped me a lot for my project, thank you very much. However, I would like to capitalize the data when saving to the table and I don't know how to do this. Could you help me on this subject. thanks again