Currently there is no option to specify which sheet in a spreadsheet should be used to receive filed forms, the first one on the list is always used.
Why this is a problem:
- We can’t use one spreadsheet to receive data from different forms (maybe it’s not a good idea in case of complex forms with repeatable groups but simple forms, why not)
- It’s confusing for our users that the target sheet must be the first on the list and I’ve solved many problems on the forum like
Question: “I can’t send forms to GS”
Answer: Please make sure your target sheet is the first on the list
We could add two options:
- a global option in General Settings -> Server under Fallback submission URL [sheet name]
- a local option for each single form like we do specifying submission url:
<submission action="https://example.com/submission" sheetName=”sheetName” method="post"/>
If not specified the forms should be sent to the first sheet like now.