Report item/option labels only rather than full texts?

We need to reduce the amount of information that is included in the HTML or Grid reports for our 16 Jotform quizzes.  In many of these tests, the questions and multiple choice answers are quite long.  Currently, all the JotForm report and integration options seem to include the entire texts of any item chosen for inclusion, but this makes viewing and compiling results awkward and inefficient: users need simply to see the question number and the option number of answers selected in most cases.

My search in the JF documentation and Forums hasn't been helpful in identifying solutions to this problem: several users have asked about customizing reports, but these queries have all received negative replies from JF staff.

Since customizing reports is not possible, is there some way to modify the forms themselves in order to allow us to capture results more concisely?  Perhaps a derivative field type which reports just the options that have been selected in a parent field?

Yes, this can be achieved - to have long option names visible on your form, but have short option names actually used on the submissions page (and in your reports).

Our most common way to achieve this is by setting up the "calculation values" of each of your options, to be the short version of your intended value:

https://www.jotform.com/help/301-How-to-Assign-Calculation-Value

For example, if your options are listed as:

a.     Stones
b.     Chalkboard
c.     Paper and pencil
d.     Bottle caps
e.     Coins
f.     Sticks of wood
g.     Sand or dirt
h.     Seeds or plants

You could use this as their calculated values:

a
b
c
d
e
f
g
h

Then, we can simply use another field, such as a Text Box field which can be made hidden, and then use conditional logic to pass the selected items on the first field into this hidden text Box field:

https://www.jotform.com/help/57-Smart-Forms-Using-Conditional-Logic

So if your users selected options a, b, and c on the first field, it would be passed by conditional logic as if they have selected a,b,c:

In your reports, you could set them up to only include these Text Box fields which display the answers your users provided.

When it comes to your question on getting the CSV file of your submissions forwarded to you periodically, as it is a different question, it has been moved to a separate support thread:

https://www.jotform.com/answers/938469

We'll be assisting you with it there, shortly. Thank you.

Thanks for this, but what if I'm already using calculation values to score the test?  For example, in the case above, each of the options is currently assigned a calculation value of 4.125 so that our hidden calculation field (bottom of the form) can add up the items checked in this and other answers for a total score for the test.  If I assign calc values of a, b, c, etc, how can the calculation field arrive at a numerical value?

That cannot be done if calculation values are already assigned to the options. A workaround, I think, would be to use a text field with the complete answer as a reference and the abc's in the field options. See this test form:

https://form.jotform.com/62717634232959 

ok, thanks.