What is JotForm?
JotForm is a free online form builder which helps you create online forms without writing a single line of code. No sign-up required.

At JotForm, we want to make sure that you’re getting the online form builder help that you need. Our friendly customer support team is available 24/7.

We believe that if one user has a question, there could be more users who may have the same question. This is why many of our support forum threads are public and available to be searched and viewed. If you’d like help immediately, feel free to search for a similar question, or submit your question or concern.


  • Profile Image

    Google Spreadsheet: select which fields to include or exclude

    Asked by La_Facultad_Invisible 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.

    integrated Emails integrate privacy policy
  • Profile Image
    JotForm Support

    Answered by Boris 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

    Answered by La_Facultad_Invisible 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
    JotForm Support

    Answered by Boris 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
    JotForm Support

    Answered by alp_deniz 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

    Answered by La_Facultad_Invisible 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
    JotForm Support

    Answered by alp_deniz 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

    Answered by La_Facultad_Invisible 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!