Create an Input Sheet with a Submit Button in Google Sheets to add Data to a Log: Apps Script Part 1

In this tutorial, we create a data input sheet to help log data to a data log in Google Sheets. In this first part of the tutorial, we are creating the layout of the Data Input sheet including setting up the input cells with data validation, providing instructions and guides, named ranges, creating the button and assigning it to our script.
If you want to skip ahead to the code for this tutorial check out the playlist and select the 3rd video.

If you like the video, check out my website:

You can find out more about how to append and manipulate Google Sheets data in these tutorials:

00:00 Intro
00:19 How the Input Sheet works.
01:40 Building the Input Sheet tab.
02:32 Set up input fields.
08:41 Instruction for first time users.
11:32 Add data validation to the input cells.
14:55 Setting the named range of the input cells.
15:31 Adding and connecting the submit button.

Here is the link to just Google Apps Script tutorials:

#GoogleSheets #GoogleWorkspace #GoogleAppsScript #AppsScript #Spreadsheets

[publiusii]

Great tutorial. I learned about GAS less than an hour ago and was able to fallow along and adapt the contents to accomplish my goal. Thanks so much

[YABEEful]

you just made my day.. my life..! You are a genius..!! 🙏🙏

[temyraverdana]

Thanks, a very basic but useful video. I like it.
See you next

[terrycoldewey]

Awesome...thank you for this video!! Can you tell me how to get the data to auto sort by date when I input new data?

[RadcliffeBromfield]

Great Job, is this for a single user or can multiple users use the form to submit at the same time and run the script?

[emmadkareem]

Nice tutorial. To me, the icon is far from pretty! Thank you.