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: [ Ссылка ]
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: [ Ссылка ]
You can make a copy of the Google Sheet used in the video here:
[ Ссылка ]
Ещё видео!