Easy Data Entry in Google Sheets with onEdit Apps Script for Mobile-Friendly Solution

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. This solution uses an onEdit script which means you can use this on the app or a mobile browser, which allows this functionality to work even when using a tablet or a mobile phone.

At the end of the video, I also show you how to do an installed trigger, which means anyone can use the form without authorizing the script.

You can make a copy of the final Google Sheet & Apps Script here: https://bit.ly/47iGIx9

If you want to check out the other videos I've made on adding or managing data in Google Sheets with a form, check out the original video here:
https://youtu.be/TVkRFV4DLR0

Or if you want to take this concept to the next level, check out our Part 2 video here, which adds update/retrieve/delete functionality: https://youtu.be/hZSP1C1RWtM

Тэги:

#Google_Sheets #google_app_script #mobile_data_entry #tutorial

Скачать видео