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

    Encrypted Form: Scale Rating field always shows a value of 1/5 in final submission

    Asked by URI_JOT_Forms on August 22, 2016 at 07:35 AM

    2 questions:

    1) I used 3 scale rating fields in an employee evaluation.  The form was set up with 1-5 results.  The results show 1/5.  How do I view what the employee entered?

     

     

    2) I also encrypted the form.  I can view and print the form individually with the key I saved.  I can download the file to csv or excel... however, how do I decrypt the Excel file?

     

    Terry

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

    scale rating showing submission
  • Profile Image
    JotForm Support

    Answered by Nik_C on August 22, 2016 at 08:57 AM

    I cloned your form and did a test submission and this is how the result looks like in my email:

    So I'm not sure if you had something else in mind by any chance?

    Regarding the second question I opened a separate thread for you and you can find it here and we will attend it there.

    Thank you!

  • Profile Image

    Answered by URI_JOT_Forms on August 22, 2016 at 12:29 PM

    I'm not getting the email confirmations as they are encrypted.  When I view the submissions in the JotForm tool, I don't see the detail.  See below:

  • Profile Image
    JotForm Support

    Answered by Nik_C on August 22, 2016 at 12:54 PM

    You can receive submissions even when your form is encrypted.

    In that case, if you submit the form the rating will be, based on what is selected, like this:

    So, 4 will be 4/5, 3 will be 3/5 and so on:

    Hope it helps, if you have further questions please let us know.

    Thank you!

  • Profile Image

    Answered by URI_JOT_Forms on August 22, 2016 at 01:23 PM

    I just tested "my form" again... I input "5" on all 3 questions.  When I went to print it was fine and showed "5"... But the submission results all show "1".

  • Profile Image
    JotForm Support

    Answered by Charlie on August 22, 2016 at 02:54 PM

    I was able to replicate the problem, it seems like this is happening when you enable the Encrypted form feature.

    Here's how I replicated the problem:

    1. I created a new form and added a rating scale field. You can see that the encrypted form feature is enabled (it shows the green lock icon on the submit button).

     

    2. I then filled out the form: https://form.jotform.com/62346133635958 and selected 4 in the rating scale field.

     

    3. When I view my submission, you can see that all the rating scale field shows 1/5. 

     

    However, if you disable the encryption feature, the scale rating field will work as expected. Let me forward this to our developers to have it checked and fixed. Apologies for the inconvenience.

  • Profile Image
    JotForm Support

    Answered by NeilVicente on September 01, 2016 at 07:38 AM

    Hi,

    This is now fixed for new submissions.

    Regards,