Support » Plugin: Google Forms » Multiple Sheets – Select Individual Ones?

  • Resolved Phil

    (@owendevelopment)


    Hi,
    LOVE this plugin – installed and got it working straight away. It’s great work.

    Question:
    I have a spreadsheet which has sheets for each month. Can I embed a form and specify a sheet to use? With multiple sheets, it creates a link at the top of the embed which links to a HTML page with some Google default text in and the data.

    If there’s a way to target one sheet with the embed code, this plugin will make a huge difference for me 🙂

    http://wordpress.org/plugins/wpgform/

Viewing 6 replies - 1 through 6 (of 6 total)
  • Plugin Author Mike Walsh

    (@mpwalsh8)

    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.

    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?

    Plugin Author Mike Walsh

    (@mpwalsh8)

    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.

    Phil

    (@owendevelopment)

    Hi, did you manage to get this working?

    Plugin Author Mike Walsh

    (@mpwalsh8)

    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.

    Plugin Author Mike Walsh

    (@mpwalsh8)

    Marking resolved, v0.59 was released today which handles rudimentary display of Google Spreadsheets as tables.

Viewing 6 replies - 1 through 6 (of 6 total)
  • The topic ‘Multiple Sheets – Select Individual Ones?’ is closed to new replies.