Google Spreadsheet: select which fields to include or exclude

  • Profile Image
    La_Facultad_Invisible
    Asked on June 23, 2015 at 03: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.

  • Profile Image
    Boris
    Answered on June 23, 2015 at 06: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.

    I hope this helps.

  • Profile Image
    La_Facultad_Invisible
    Answered on June 23, 2015 at 08: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.

  • Profile Image
    Boris
    Answered on June 23, 2015 at 09: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.

  • Profile Image
    alp_deniz
    Answered on September 24, 2015 at 01: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

  • Profile Image
    La_Facultad_Invisible
    Answered on September 24, 2015 at 04: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!

  • Profile Image
    alp_deniz
    Answered on September 24, 2015 at 09: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

  • Profile Image
    La_Facultad_Invisible
    Answered on October 06, 2015 at 03: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!