Easy Data Entry: 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.
If you want to take this concept to the next level, check out our Part 2 video here, which covers adding update/retrieve/delete functionality: • Make CRUD Easy! Manage...
You can make a copy of the Google Sheet used in the video here:
bit.ly/3W1vveT

[@fatimagajia4823]

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.

[@SheetsNinja]

Awesome, thanks for sharing!

[@mariacamilabm2870]

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

[@SheetsNinja]

Awesome, glad I was able to help! I love the simple solutions.

[@deniyamtanwar3608]

very short and efficient code thankyou

[@SheetsNinja]

Glad it was helpful!

[@nvrdyingofficial5498]

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?

[@nvrdyingofficial5498]

btw, your codes are the very short and easy to understand. thanks! ^_^

[@SheetsNinja]

I just recorded a part 2 for this video that includes save/update/retrieve/delete functionality. th-cam.com/video/hZSP1C1RWtM/w-d-xo.html

[@lesliefoster9027]

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

[@SheetsNinja]

It gets easier! You can make a copy of the final project and play around with it to learn more, and if you break it, you can go back to the original again. 😉

[@AlmiraPamplona-ok1zf]

What if I the database to be in a new spreadsheet? How to do it?

[@SheetsNinja]

So where we add the let targetSheet line, we'll have to insert a row above like this;
let targetSS = SpreadsheetApp.openById(NEW_SPREADSHEET_ID);
let targetSheet = targetSS.getSheetByName("TARGET_TAB_NAME");
And then proceed with the rest of the code .