POWr Help Center

Connect Google Sheets to POWr forms

Follow

Comments

8 comments

  • Avatar
    Courtney Quinn

    Integration of Google Sheets and real time feed works nicely. But it seems there are significant bugs that keep it from collecting accurate data. Unless I'm doing something wrong...

    Here's the problem:

    • The header row of the Google Spreadsheet holds all of the Form Element's Labels. This header row updates with every form that is submitted.
    • If someone chooses not to answer a non-required question, then the header row automatically updates to not include the Form Element Label. 
    • Therefore, if someone submitted an entry that answered that non-required question, their answer now falls under an inaccurate header.

    Is there any way to lock the Header Row so it includes all of the possible Form Element Labels? (I already tried to lock the editing permissions on the Google sheet.) Or, is there a way to fill a non-required field with a place holder, even a "N/A" so that it doesn't skew the data if someone chooses not to answer?

    This is not just helpful. It's necessary.

  • Avatar
    Pilar

    Hi Courtney!

    Thanks for reaching. Great feedback! That is obviously not supposed to happen. I'll shoot you an email so you can send me the link to your form. Our engineering team will be happy to take a look and help you make everything work correctly!

  • Avatar
    Cmichaeloyer

    I have just experienced a problem with the google sheets integration and can't figure out how to resolve. I had everything setup and it was working fine. Somehow, I deleted the file in my google drive. I went back into Form Builder Plus and tried to set it up again. I see no way of correcting the problem. When I click on go to google sheets it tells me the file has been deleted or moved; but no way to correct my mistake. If anybody knows a fix, please inform me. I would greatly appreciated any help I can get. Thanks again,

  • Avatar
    Pilar

    Hi there!

    There should be a way to move the file out of the trash if that is where it's currently stored in your Google Drive folder. 

    Typically, "Move out of Trash" appears as an option in the modal that appears in your Google Drive when clicking on the link. 

    If that isn't happening, please send a link to your form as well as a screenshot of the error to our support team and they'll be happy to take a look!

  • Avatar
    Cmichaeloyer

    I had deleted it from my trash also. I’ve contacted google and they have restored the file; but haven’t had a true test yet. I will know more once a form is filled out. Thanks for replying so quickly.

  • Avatar
    Kerry Krienitz

    Hello! 

    I connected my form to the google sheet but it only seems to work sporadically.  Sometimes it autopopulates and sometimes or quite often it doesn't auto fill for the form respons submissions.  Why does it only work sometimes?

     

  • Avatar
    Pilar

    Hi Kerry!

    Did you frequently change fields in your form? If the headers in your form change, that can cause the fields to not merge correctly. I'd recommend submitting a support ticket with more details, including a link to your form and a share link to your Google Sheet, so that our engineering team can take a look. 

    Thank you! :) 

     

  • Avatar
    Rashonda Williams

    When trying to "view google sheet", I keep getting a blank screen.

Please sign in to leave a comment.