Create a Simple Data Entry Form: Enter Data Using a Form in Google Sheets & Apps Script

Here's a quick video demoing using Google Apps Script to save data from a simple form in Google Sheets to a table/database format in a different tab.

You can make a copy of the Google Sheet used in the video here:

[fatimagajia]

This code is very short and sweet thank you. The only thing I had to change in the script was to write "form" in lowercase instead of "Form", and it all worked smoothly.

[mariacamilabm]

OMG FINALLY ❤THIS IS EXACTLY WHAT I WAS LOOKING FOR. ✨🙏 THANK YOU

[lesliefoster]

My head hurts from trying to understand but thank you for this.

[KaluuchePraise]

Please, I wanted to create a form to serve as receipt for my business. And since customers may not but all my products, I need the form to match the product bought to the right column in the data base. How can I achieve this?

[kimdongryeong]

Thanks for your great tutorial! It's really helpful! By the way it doesn't work on Android phones, right? What can we do for Android phones?

[meliodas]

ang because of this i love but may i ask how did you do it or you just hide the rest of the column and rows that aren't use?

[nvrdyingofficial]

do you have a video about data entry that can also retrieve the data and update it on the same field? like the excel forms?

[deniyamtanwar]

very short and efficient code thankyou

[dcjohnson]

Is there a way that multiple users can use the form simultaneously without interfering with each other?

[honey_island]

This was a great tutorial, I used the same script but i keep getting an error message that says "Form not defined"

[thefaraon]

hey i get the exception that my parameters for the getrange function are (number, number, number, null)

[Fifi-qlzc]

my man, I can barely see your code and you're barely explaining anything