- uolaosinclusionAsked on September 21, 2016 at 01:36 PM
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?Alternatively, is there a way to transmit CSV reports automatically on a periodic basis so that the data could be processed elsewhere? Or are there other post-processing options that would allow us to draw the data from JF, trim the results as needed, and then display ourselves?
- BorisAnswered on September 21, 2016 at 04:06 PM
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:
For example, if your options are listed as:
c. Paper and pencil
d. Bottle caps
f. Sticks of wood
g. Sand or dirt
h. Seeds or plants
You could use this as their calculated values:
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:
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:
We'll be assisting you with it there, shortly. Thank you.
- uolaosinclusionAnswered on September 28, 2016 at 02:45 PM
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?
- JotForm SupportWelvinAnswered on September 28, 2016 at 08:25 PM
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:
- uolaosinclusionAnswered on September 29, 2016 at 12:03 PM