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.
Google Spreadsheet: select which fields to include or excludeAsked by La_Facultad_Invisible on June 23, 2015 at 03:49 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.
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.
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.
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.
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.
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.
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!