I am not sure I follow you here – which sheet a Google Form stores the data on is controlled when the form is created and published. My plugin only uses the published form URL so if you are able to target a specific sheet with your form in Google’s normal usage model, there shouldn’t be any reason why it wouldn’t work with my plugin.
Thread Starter
Phil
(@owendevelopment)
It’s my explanation, sorry.
What I mean is I have a Google Doc Spreadhseet (a workbook), but I have seperate sheets as tabs along the bottom, so within the same workbook (the same form), I have seperate sheets for each month and wondering if there’s a way to target a particular sheet.
The plugin at the moment is pulling in all sheets from the spreadsheet as seperate links. I can kinda target each by adding &gid=2 on the end of the url but it that seems to choose the active sheets while still displaying all sheets.
Does that make sense?
I’ll have to try and mock this up. The last time I played with a multiple sheet spreadsheet the &gid=N URL parameter was the right answer. Google made a major revision to Forms earlier this year and a lot of things changed, it wouldn’t surprise me if this is one of them. As I recall, one of the things you can set when defining the form is where you want the responses to go and I think you can select a specific sheet within a document.
Thread Starter
Phil
(@owendevelopment)
Hi, did you manage to get this working?
No, I never went back and looked at it. In fact, I am still not sure I understand your question.
When you create a Google Form you can choose where you want the responses to go. One of the choices Google offers is a sheet within an existing spreadsheet. Wouldn’t this do what you want? You’d have to go back and revisit the Form each month to tell it to direct responses to a new page in your spreadsheet but I am not sure how else you’d do it.
Marking resolved, v0.59 was released today which handles rudimentary display of Google Spreadsheets as tables.
