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

    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?

    Thank you,

    Dan

    Page URL:
    https://form.jotform.com/61124507182145

    encryption and form data integrate not visible
  • Profile Image
    JotForm Support

    Answered by Kevin_G on April 22, 2016 at 08:11 PM

    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.