POWr Help Center

Connect Google Sheets to POWr forms

Follow

Comments

2 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!

Please sign in to leave a comment.