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

Подписаться 2,8 тыс.

Просмотров 10 тыс.

50% 1

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! Data E...
Or if you want a mobile-friendly solution or one that will work for anyone without having to authorize the script, check out this alternate tutorial here: • Easy Data Entry in Goo...
You can make a copy of the Google Sheet used in the video here:
bit.ly/4eaCfyI

Опубликовано:

30 сен 2024

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 26

@joyful_journey24 7 дней назад

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

@SheetsNinja 7 дней назад

You need to make sure the tab name matches between the Google Sheet and the script (sometimes a blank space at the beginning of end of a tab name can throw you off in the script)

@meliodas00777 4 дня назад

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

@SheetsNinja 4 дня назад

So glad this was helpful! You can right-click on any single column or row number (e.g. the part where it says A,B,C etc. or 1,2,3, etc) and delete that single row or you can select multiple rows or columns and do the same thing. So for example if you want to delete all the rows after row 30, you can click on "31", scroll down, hold down Shift and then click on "1000", right-click and select "Delete 969 rows"

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

@dcjohnson7615 26 дней назад

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

@SheetsNinja 26 дней назад

You can duplicate the form entry tab and have a separate tab for each user. Then in the script you can just use an or statement for the tab name. E.g. If ((tabName == 'Form 1' || tabName == 'Form 2' || tabName == 'Form 3') && val == 'Submit')

@dcjohnson7615 21 день назад

Thank you so much. One last question, is there a way to make it able to submit without having all cells filled in?

@SheetsNinja 21 день назад

@@dcjohnson7615 Currently there is no restriction on cells having to be filled in to submit the form, so it will work as is.

@kimdongryeong8331 2 месяца назад

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?

@SheetsNinja 2 месяца назад

I just made a new version of this video using an onEdit script, which makes this functionality available for mobile phones or tablets: ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-K5uOSI5i8ME.html

@thefaraon6079 3 месяца назад

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

@SheetsNinja 3 месяца назад

It sounds like you might need to update the range where the script is getting the data. If it's saying the last one is null then the script is likely not getting any data. If your "FORM" tab looks different than the FORM tab in the template, you will want to modify the range where it's getting the data. That is this line: let data = form.getRange(5,5,form.getLastRow()-4,1).getValues().flat(); This assumes that the data entry is starting in E5. If you are starting in B2, then you would need to modify to: let data = form.getRange(2,2,form.getLastRow()-1,1).getValues().flat();

@fatimagajia4823 10 месяцев назад

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 10 месяцев назад

Awesome, thanks for sharing!

@mariacamilabm2870 10 месяцев назад

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

@SheetsNinja 10 месяцев назад

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 7 месяцев назад

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 7 месяцев назад

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

@SheetsNinja 7 месяцев назад

I just recorded a part 2 for this video that includes save/update/retrieve/delete functionality. ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-hZSP1C1RWtM.html