1. What is the problem? Be very detailed.
I have a Google Sheets file with 5 sheets. I want to be able to submit data to a specific sheet, and I am willing to use one response sheet per ODK form (i.e. Form 1 submits to Sheet 1, Form 2 submits to Sheet 2, etc. But Sheets 1-5 exist within the same Google Sheet). However, the shared link does not respect the gid number that Google uses to identify the sheets. Furthermore, the ODK form only uploads data to the left-most sheet in my workbook. So if I rearrange Sheet 3 to be on the left of Sheet 1, the next submission will appear on Sheet 3.
I have tried these URL syntax:
Am I missing something? Or is it not possible to specify the sheet to which I want my data uploaded?
2. What app or server are you using and on what device and operating system? Include version numbers.
XLSForm on ODK Collect, on Google Pixel 2. Sent forms go to Google Drive.
3. What you have you tried to fix the problem?
Experimented with different sheet gids, Google Sheets URL syntax, rearranging sheet order.
4. What steps can we take to reproduce the problem?
Create an XLSForm and a Google Sheet with multiple sheets. Use #gid=[01234567yoursheetIDhere] in the submission URL that points to a specific sheet within your Google Sheet. Send the form and observe the results.
5. Anything else we should know or have? If you have a test form or screenshots or logs, attach below.
It's important to my project that the sheets all "live" in the same file, as other non-techy people will want to access the raw data and possibly make corrections or input directly into the sheet. The next best option would be to create a separate Google Sheet document per ODK form, but that is less ideal as it is not very streamlined. I figure since Google Sheet already generates a unique gid for each individual sheet, that this should not be too difficult to do with ODK Collect submissions?