Google Form and Google Spreadsheet

I LIKE SQL Hello I read the attached [login to view URL] and I read and tested the Google Spreadsheet SQL query feature. Unfortunately the Spreadsheet SQL is not powerful enough to meet your requirements. Spreadsheet SQL provides only a subset of commands that standard relational databases provide - it doesn't even have JOIN clause. I understand that you want to auto-generate reports based on the data entered via Google Forms. I offer you to create a Google Script that will run each time the Form is submited and it will generate/update the excel spreadsheets. The script would read the data and then filter it and segment it based on the year/month and the user. The names of report files would be in the following format: "report_YYYY_MM" where YYYY is year and MM is the month. Inside the file there would be sheets for each user (Table 1) and extra tab that would contain consolidated data (Table 2). For each month a new report file will be created and then kept up-to-date. I also offer you a help in setting up the script. And in making sure everything works correctly. If you have any questions I will answer them gladly.