- pascoeaAsked on January 27, 2015 at 05:48 PM
I am creating a somewhat lengthy survey, I went through and gave each element a name under "field details" (Eg: timeCardFrequency). But when I pull the report in excel it uses the question name (Eg: "How often are time cards filled out") for the column header. Is there any way I can use the name instead of the question for reporting?
The problem is I have a comment box under each multiple choice question, I don't want to give each one of them a name. When I do my reporting, those columns show up blank.
Thank you for your time!
(note, the example isn't the full survey)
- raulAnswered on January 27, 2015 at 07:01 PM
Unfortunately, the report is generated this way and cannot be customized.
On this case, you could add a name to each comment box and then hide it using custom CSS so it won't be displayed in your form but it will be included in the Excel report, would this be a viable solution for you?
- pascoeaAnswered on January 29, 2015 at 09:56 AM
Thanks for the reply Raul.
I like your suggestion, that is what I did. But it's not ideal. There are some boxes that I don't want to hide the label on. I'm sure a CSS guru could figure it out, but I'm not that guy. haha.
Thanks again for your time.
- JotForm SupportEltonCrisAnswered on January 29, 2015 at 12:43 PM
Sorry but I don't think that can be achieved with CSS. Columns on submissions listing or exported submissions always uses its field label not the name on the field variable. The only possible solution I could think of is to manually edit the field labels you want to appear on excel for exporting purposes and then reset the label back after exporting the submissions.