Google Sheets Form for Data Entry - Apps Script

Learn how to create a data entry form in Google Sheets using Apps Script.

00:00 Google Sheets Data Entry Form Demo
02:00 Build Form UI
07:50 Create Records
17:30 Clear Fields
20:25 Build Form Search Functionality
40:25 Edit Existing Data
51:30 Delete Records

#form #googlesheets #script

[CourtneyFay-iv]

This is fantastic. I followed this in a real use case and it totally works! My next step is dealing with a second data list that is tied to the first by that ID with a 1-many relationship. Excited to see where I can take this!

[jenni]

Thank you thank you thank you!! I've been watching your video for at least two weeks because I work long hours and I watched it over and over and I finally paid the patreon membership and was able to complete our new form. I was doing something wrong some how but I just copied and pasted everything in the end and modified it to our form's needs. lol. Keep up the great work!! Looking forward to your other videos.

[kerinahrgang]

I love when you "make mistakes" since we then get to see how you fix them! I have been able to automate quite a few spreadsheets and workbooks thanks to your lessons!!!!

[tipaysandiego]

i got an error @33:51 . TypeError: Cannot read properties of undefined (reading '0')

[blockwest]

Always a pleasure to watch your tut´s. Espacially the ones from Apps Script. Thank you, sir!

[ynurhalimi]

thank for the video, but, ..in 30:29 when i use "data.filter " then message error : "typeError : data.filer is not function", please help me, ..thank's

[NicoleR-ye]

This was great! It took me all day to do but I got it done and my form works!!

[mcdjohn]

can we add some options of manual entries also please? For example id my marketing team member has to fill this they would have the fixed product listed by=ut i they have to mentioned but it one has to fill prices manually it was sold for for multiple product. Please if you could help on this?

[wego]

This is an excellent video! Thank you for providing it. I have a question. Is there a way include instructions to clear the fields upon saving? I've been playing with it to see if I can make it work and it's just not working.

[fariady]

Thank you very much, I'm trying to incorporate this form in my spreadsheet, but I don't have the ID column in the data, can I use a second column with formula to create some sort of id for each row or maybe I can use the same search column as ID for the saveRecord? thank you

[CITYASSESSORSOFFICE]

Hi! I have tried this tutorial of yours, but it seems im having trouble at the onedit script. It is returning a TypeError: Cannot read properties of undefined (reading 'range')

can you please help on this one? thank you

[vivientan]

Hi pls advise
I follow the steps up till “search”
got 2 formula running failed
1) if(recordsFound.length === 0) return
2)


error msg
1) the “.” Problem and “===“
2) is the “[“ “]” problem and “(“ “)”

I am stuck at this point not sure how to do. Kindly advise
Thanks

[omarz]

Dude I had to stop watching, you're really good with how you explain!

[rybaxs]

This will help small-time businesses that don't have enough budget for a system.

[ThePhotographer]

Is there a way to add data to a spcific column using a pull down to pick what column it goes in?

[les.matematika.online]

what if the form sheet is separated in another spreadsheet, do you have a video about that? I'm very grateful if you have

[technogaming]

Is there a way through which multiple people can fill the form at the same time?

[tiagia]

anyway to get a copy of just the coding part so I can see it by it's self?

[donjuangyn]

I am really grateful for this video . I could apply all these tips in a new form in my job. Thank you

[Sci-TechOffice]

Thank you!! But I'm trying to figure out when editing existing data, if I want to let if(id == "A:A") (which means compare to all the values in A:A, if not then create a new record), what should I do?