Google Spreadsheet: select which fields to include or exclude

  • La_Facultad_Invisible
    Asked on June 23, 2015 at 3:49 AM

    I want to share the data that has been sent through the form I created with some people, but due to the privacy policy some data such as emails or addresses cannot be shared. So I would like to integrate some fields of the collected data but not all of them.

  • Boris
    Replied on June 23, 2015 at 6:15 AM

    I'm afraid that this is not possible at the moment with Google Spreadsheet integration. However, I would recommend that you try creating an Excel Report which does have such a feature, and can even be password protected from unauthorized access.

    You can turn off any sensitive fields and they will not appear on the report.

    Google Spreadsheet: select which fields to include or exclude Image 1 Screenshot 30

    Google Spreadsheet: select which fields to include or exclude Image 2 Screenshot 41

    I hope this helps.

  • La_Facultad_Invisible
    Replied on June 23, 2015 at 8:30 AM

    It helps indeed, thank you!

    Anyway I hope you consider to include this possibility in some future version of "Google Spreadsheets Integration", as nowadays many files are shared through the cloud.

  • Boris
    Replied on June 23, 2015 at 9:58 AM

    You are welcome, I'm glad if Excel reports will work for your needs. :)

    I have forwarded your feature request to our developers for a possible enhancement to our Google Spreadsheet Integration at some point, but we can't give you any promises on when or if it will be accepted, worked upon and included in a future version of our integration.

    Thank you for recommending it. We will let you know through via thread when/if this is implemented, or if we possibly make any similar enough feature available.

    Kind regards.

  • alp_deniz
    Replied on September 24, 2015 at 1:14 AM

    Hello,

    Google spreadsheet integration sends all submission data to the integrated sheet. However, you can simply delete undesired columns so that they won't be updated anymore. 

    It seems like a very practical solution. I hope it works for you.

    Kind regards

  • La_Facultad_Invisible
    Replied on September 24, 2015 at 4:49 AM

    Hi alp_deniz, thanks for your reply, unfortunately due to privacy issues, your solution is not applicable in our situation. The idea is to publicly share the document with all the data but for the private elements (such as emails or id's), with your solution we would have to delete these columns as soon as anyone post a new answer, and we will receive quite a lot! I hope you can implement in the near future a feature to exclude some columns also in the Google Spreadsheet Integration.

    Kind regards!

  • alp_deniz
    Replied on September 24, 2015 at 9:26 AM

    Hi,

    I would like to emphasize that deleted columns do not get updated so deleting private columns once just after integration will suffice to prevent any information from revealing.

    I stated again just to be sure. Otherwise, please let me know how deleted column data is revealed after a new answer and we will implement a solution as soon as possible.

    Thank you

  • La_Facultad_Invisible
    Replied on October 6, 2015 at 3:58 AM

    Hi alp_deniz! I am sorry but I completely misunderstood your answer. I thought that if a new answer was submitted, the deleted column will pop up again with the new private data, so that we had to erase the column over and over again.

    Being the behavior as you described, it serves perfectly to our purposes!

    Thanks, you are all awesome!