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 Entry from a For...
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 Google Sheets with...
You can make a copy of the Google Sheet used in the video here:
https://bit.ly/4eaCfyI