Google Forms is a common platform that is used to edit and record information for surveys. Google Sheets can be used in conjunction with Google Forms, allowing all records to be instantly saved to Google Sheets once it is recorded on the Google Form. This platform allows an easy-to-use “database” system that works exactly like Excel, but in mobile form. Great for clients with in-depth Excel knowledge but not much database familiarity.
Google Forms and Sheets have much more functionality that you would think. Once data is in the Google Sheet, a script can be run to do just about anything with the data, much like a regular database. For our project we created a script that would archive all data from one sheet to another sheet.
How to use Google Forms: https://gsuite.google.com/learning-center/products/forms/get-started/
How to use calculations in Google Sheets: https://support.google.com/docs/table/25273
How to create scripts in Google Sheets: https://developers.google.com/apps-script/guides/sheets/functions
NOTE: You will need to know Java Script to code in Google Sheets, but your knowledge in C# from 333k will help you understand most scripts that are readily available
The functionality is endless when it comes to Google Forms/Sheets, and is a good platform for companies that don’t have existing processes and a limited budget!