Jotform Tables: When a submissions are downloaded as an Excel File, I'm missing a column.

How to shown values in result or submission?

I can't find values in submission when I downloaded it

Hi tulerahmad,

Thanks for reaching out to Jotform Support. Can you explain a bit more about the issue, so I can get a better idea of what's happening? It would also help us to understand what’s happening if you could take a screenshot and send it to us. We have a guide here explaining how to do that.

Once we have a better idea of what’s going on, we’ll be able to come up with a solution.

I've set values in my form single choice. One for correct answer and zero
for incorrect answers.
I tried to fill it, submitted it and when I downloaded the result as excel
file, where could I see the values 1 and 0 before
...

Hello Rahmad,

Is the question to which you assigned calculation values currently visible in your Jotform Tables? If it's visible whenever you download the submissions as an Excel file, it has to be there. But if none, please ensure that the questions are currently set to be visible. Let me show you how to manage the columns in your Jotform Tables using my sample tables below:

1. Open the Jotform Tables page and left-click on the Columns on the right side of the page.

2. You can either search for the missing elements in the search field or just click the select all option to make all elements visible as a column. 

We have a guide about How to Show and Hide Columns in Jotform Tables that you can check out. After confirming that all the columns are selected, and the columns you are looking for are still not visible in your Jotform Tables, please note that there's another way to manage your columns. Let me show you it's done:

1. On the right side of the tab name, click on the Three Dots icon.

2. Click the Gear icon labeled Manage Columns.

3. You can add the form fields back by clicking the fields from the left side of the window, then click on Update.

We also have a guide about How to Add and Organize Columns in Jotform Tables that you can check out.

Give it a try and reach out again if you have any other questions.

Hello Rahmad,

I misunderstood your issue. If a calculation value is assigned to the fields, you need to use a Form Calculation Widget to pull its values. Let me show you how it's done:

• In Form Builder, click on the Add Form Element menu on the left side of the page.
• Under the Widgets tab, search for the Form Calculation Widget and add it to your form.
• Click on the Wand Icon of the widget, click on the Add Field, and select the first question. 
  
  
  

Please note that if you have 50 questions, you will need to add 50 Form Calculation Widgets and ensure that they are hidden in the form so the respondents won't see them. Take a look at the screenshot below to see my results:

Give it a try and reach out again if you have any other questions.