Encrypted Form Submission Data with Spreadsheet Integration and Prepopulate to Another Form

  • Profile Image
    shirley.pccw
    Asked on February 16, 2021 at 12:05 AM

    Hi Jotform,

    I have my 1st form encrypted and populated in Spreadsheet

    1613450858_602b4e6a5de70_

    I would like to be able to populate this answer to a 2nd form for version control and in a secured manner.

    Will you / your team be able to suggest ways to do this?

    • possible to decrypt the submitted data on my side (locally) from the private key you generate for me?
    • API solution?
    • combine with Spreadsheet to Form widget?

    1613451566_602b512ebec0d_

    You may try populate the encrypted dummy data using below Code using the Spreadsheet to Form widget in the form:

    https://form.jotform.com/210458145145451

    1613451473_602b50d10219e_

    I really hope I can populate the data to a 2nd form securely from end to end, and so it requires decryption to view the 2nd form (From prepopulated data).

    Use Case:

    1. User 1st Form Submission + Encryption --> Recorded (i.e. Version Control)
    2. User Adjustment in 2nd Form
    3. User Decryption
    4. User Adjustment made
    5. Re-Submission Encryption
    6. Recorded (i.e. Version Control)

    Please let me know and any suggestions will be greatly appreciated!
    Thanks a lot!

  • Profile Image
    Vanessa_T
    Answered on February 16, 2021 at 02:41 AM

    Please note that if you encrypt the form, encryption and decryption happens on browser-side only, as such, there is no way for us to decrypt it or restore it in case you lose your private key, as such, please use it with caution.

    https://www.jotform.com/help/344-encrypted-forms-and-how-to-use-them

    If you are concerned with security, you may check our security page:

    https://www.jotform.com/security/

    Meanwhile, to pass a data to another form, the easiest way would be to prepopulate it via URL parameters.

    https://www.jotform.com/help/351-how-to-automatically-pass-form-data-to-another-form

    However, if you'll be encrypting the first form, the data that is sent to our servers are already encrypted, as such, the data that will be passed to your second form will also be encrypted.

    As a workaround, you can create a script that will decrypt the data, then set your form's Thank You Page to redirect to your script.

    https://www.jotform.com/help/51-how-to-post-submission-data-to-thank-you-page

    Your script should decrypt the data using base64 openssl then redirect to your 2nd form using URL parameters.

  • Profile Image
    shirley.pccw
    Answered on February 16, 2021 at 03:00 AM
    Hi Vanessa,
    For below you suggested - if I am not mistaken it is a non-secured http
    POST method right? Is there any secured option?
    As a workaround, you can create a script that will decrypt the data, then
    set your form's Thank You Page to redirect to your script.
    https://www.jotform.com/help/51-how-to-post-submission-data-to-thank-you-page
    Thanks again.
    ...
  • Profile Image
    shirley.pccw
    Answered on February 16, 2021 at 03:22 AM
    Hi Vanessa,
    And is this solution HIPAA compliant if I upgrade to Silver/HIPAA account?
    Thanks again
    ...
  • Profile Image
    Sam_G
    Answered on February 16, 2021 at 04:23 AM

    Hi Shirley.pccw,

    By default, our forms are secured.

    You may want to use a webhook.

    Please note that the webhook integration is available with HIPAA-enabled accounts. You may add the URL provided by the application in the webhook integration to receive the data from the form. The data should be sent without any issue using the webhook integration. You may test the webhook integration using one of the following webhook testing sites.

    https://requestbin.com/

    https://requestcatcher.com/

    Please give it a try and let us know if you need any further assistance. We will be happy to help. 

  • Profile Image
    tommy
    Answered on June 24, 2021 at 02:19 AM

    Hello,

    Based on your previous question on prefill forms, we wanted to let you know that Jotform Prefill has been launched! Now you can create free prefilled forms that can be connected to CRM, Jotform Tables, and previous submissions to create pre-populated forms with unique URLs. We are so happy and excited to welcome you to explore the elements of Jotform Prefill and what you can do with them.

    You can find further information below, if you are interested.

    You can start exploring now from the Form Builder page of any form you want. Simply click the “PUBLISH” tab in your Form Builder and click the “PREFILL” option:

    oglIhLXL3NJ-lIjtO8ZZOvvpKPemuKL1ObLw-cse

    1- Manual Prefill

    You can fill the form manually and share with your users easily. When you send the URL, users can see the populated data by prefilling.

    You can create a prefilled form manually by entering the information like form filling experience and clicking “Save” at the right top. Then, a prefilled form URL that can be edited will be generated by the system.

    1624428946_60d2d192b9a6c_

    By clicking the 3-dot menu button, you can see options for the created prefill form. These options are explained in this screenshot;

    BCgwZ-S96eflOqqQANPfICT9oikX4r4RiS-TMjPK

    Also, you can check this guide: How to Prefill Form Fields With Data You Provide with Manual Prefill?

    2- Jotform Form Prefill

    You can prefill the fields by your old submissions. Thus, you can use existing information or imported data in Jotform Tables. For each record in Tables, you can create a prefilled URL by clicking the “Add a new Prefilled URL” button. After the submissions selection, you can click the “Create” button and prefilled URLs will be generated. After that, all created prefilled URLs will be seen at the record list.1624429158_60d2d2663efd0_

    By clicking the 3-dot menu button, you can see options for the created prefill form. These options have been explained in this screenshot;

    24z_RcI6AWEvn09SzpZY2fmzVQbuzc8rZgZM2r_Z

    Also, you can check this guide: How to Prefill Form Fields With Data From Another Form With Form Prefill?

    3- Jotform Tables Prefill

    You can prefill the fields by selecting rows from Jotform Tables. Thus, you can use existing information or imported data in Jotform Tables. For each submissions in Tables, you can create a prefilled URL by clicking the “Add a new Prefilled URL” button. After the submissions selection, you can click the “Create” button and prefilled URLs will be generated. After that, all created prefilled URLs will be seen at the record list. 

    1624429483_60d2d3ab3427e_

    By clicking the 3-dot menu button, you can see options for the created prefill form. These options’ explanations can be seen in this screenshot;

    b12p4HJv-Io-gLo9a_g3j0PBADgFvz7i3M70bMat

    Also, you can check this guide: How to Prefill Form Fields With Data From Other Tables with Table Prefill?

    4- SalesForce Prefill

    You can integrate your forms with a Salesforce account and match Salesforce fields with form fields. For each record in Salesforce, you can create a prefilled URL to be sent to your users. For the SalesForce prefill, you need to authenticate your Salesforce account for prefilling.

    b5WSOOHs6grKitRLvrgoTI5UKP55dwN8x8Z-U7LE

    By clicking the 3-dot menu button, you can see options for the created prefill form. These options can be seen in this screenshot;

    M1CcJRcmgZOl7W-wV4M8bbnt5ZeR0CHjEv2QPGH8

    You can visit the following user guide for more details: How to Prefill a Form Using the Data From Salesforce.

    5- Hubspot Prefill

    You can integrate their form with a HubSpot account and match Salesforce fields with form fields. For each record in HubSpot, you can create a prefilled URL to be sent to your users. For the Hubspot prefill, you need to authenticate your Hubspot account for prefilling.

    GydGgCVSdTH83Mr_kdkX_50R8_Q7FqKby_CD_E_j

    By clicking the 3-dot menu button, you can see options for the created prefill form. These options can be seen in this screenshot;

    2lTEeUXI_J2TL2tMy-9FnPivD4Pe2CFo11hUoOC6

    You can visit the following user guide for more details: How to Prefill a Form Using the Data From Hubspot

    6- Editable - Read Only Options

    In addition to these, You can also edit prefilled form settings for filled fields as editable by the end-user or read-only. If read-only is selected, users cannot change the prefilled information.

    w7dtAhU1jx_l1fRPfXWlIoHP7kPOqBMxXdDPrJO8

    FOR MORE INFORMATION ON JOTFORM PREFILL, you can always visit our product page → Announcing Jotform Prefill and Send pre-populated forms

    In addition to these, there is a detailed guide about What Is Jotform Prefill And How Does It Work?

    Thanks for using Jotform!