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

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

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

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! Manage...
You can make a copy of the Google Sheet used in the video here:
bit.ly/3W1vveT

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

11 май 2023

Ссылка:

Скачать:

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

Добавить в:

Мой плейлист

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

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

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

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

Awesome, thanks for sharing!

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

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

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

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

@thefaraon6079 17 дней назад

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

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

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();

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

very short and efficient code thankyou

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

Glad it was helpful!

@nvrdyingofficial5498 4 месяца назад

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

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

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

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

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