JotForm is a free online form builder which helps you create online forms without writing a single line of code. No sign-up required.
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.
How to integrate an encrypted form with Google Spreadsheet?Asked by dgrote on April 22, 2016 at 06:27 PM
If I choose to encrypt form data and to integrate a form with Google Sheets, the data is not visible to me in GS. I chose the option of encryption because of highly sensitive information in the form. Am I correct in enabling encryption? Is there a trick to getting the Google Sheet to open with the form data visible rather than garbled?
I do not think that this could be possible to do, if you would like to have your submitted data available on your spreadsheet then you will need to disable encryption in your form.
**Do note that the already encrypted data will be still encrypted, only new received data will be shown normally.
Also, let me tell you that our forms are secure, so all of our links load over a secure URL (HTTPS) it means that they are being transferred using this security protocol even when you are using our integrations.
If you are afraid of the data being saved in JotForm then you may disable encryption and delete your submissions as soon as they come, as you have already your form integrated with Google Spreadsheet you will not loose any data.
Here is the app that will help you to delete submissions as soon as they are received: http://apps.jotform.com/app/auto_delete_submissions.
So you will have your data saved only in your spreadsheet.