Google Form - to Table (Setting) -?

Question

Google Sheets

Hi all. There are some questions:
1. Created the form, connected the table to it. The form is filled out - the answers are written in the table. But it’s worth editing the form, for example, creating some new question in the form (say, at the beginning of the form), then in the table this (new created answer) appears at the end of the table, and not where it is added in the form. How to fix it?
2. I made two tabs in the connected table (to fill in the data with different people, but when filling out the form, all the answers fall into the first sheet, but it is necessary that when filling in by some people, the answers fall into the 1st sheet, when filled in by other people into the second sheet. How it to implement?ie the form and the table one, but the table needs two sheets (tabs)?

Answer 1

You can use Google Apps Script to create a script to deploy it as an app and accept POSTs from a form on the site. In the script itself, connect the desired table and, checking the received POST, put the data in the desired sheet