Google integration and live edits

  • Profile Image
    akozar
    Asked on March 19, 2013 at 12:59 PM

    I can't find a good answer on this searching. With google spreadsheet integration it is unwise to edit the fields in the first row. Does hiding the row or columns also break integration?

    The reason I ask: My users would like to review and comment on form submissions as they come in, what's the best way to do that?

     

    Thanks!

  • Profile Image
    Welvin
    Answered on March 19, 2013 at 01:55 PM

    Hi,

    That's right. Never alter the first row in spreadsheet results because that will break the integration. My suggestions are these:

    1. Create a Grid Listing or HTML Table Listing to share them the submissions so they can review.

    2. Ask them to Email you for their comment

    A two way process but the best way to prevent breaking integration. Please kindly try it and let us know if you have questions.

    Thanks

  • Profile Image
    akozar
    Answered on March 19, 2013 at 02:05 PM

    In our organization that will result in me managing a lot more of the data flow than is reasonable. I'm considering adding a hidden box to the form, that should create a new column on the spreadsheet which we can then use internally for review and approval of submitted data.

    Would that be a good workaround? Is it going to do anything to the existing entries?

    Thanks!

  • Profile Image
    KadeJM
    Answered on March 19, 2013 at 02:56 PM

    No it shouldn't cause any problems as long as you don't remove the hidden box name otherwise you will have to reintegrate google spreadsheet since that would break it. All you need to do after this is to manually edit and enter the approval status after that.

    Please Screenshots (You can see the " TEST C " as the hidden box field which doesn't show up on the form but creates a Column for it in gSheets) -

     

     

  • Profile Image
    akozar
    Answered on March 19, 2013 at 03:09 PM

    Thanks, that worked great! It's weird that the integration creates a new file when the form is changed rather than modifying the existing file.

  • Profile Image
    Mike_T
    Answered on March 19, 2013 at 03:20 PM

    Some users prefer to have all the data in original form format, otherwise the thing can be messed up. However, we have in mind the option with updating the existing spreadsheet, it will probably be implemented at some point in the future. Thank you.