- BurkhartAsked on July 31, 2015 at 08:14 AM
On my test validation form, I want a space in between all of the users' answers in excel. I have tried inputting the CSS code on the overall form, but it's still coming back with no spaces.
This is what I did:
1) Looked at the ID element which is called "testingOptions"
2) Took the code I found in another question post which is:
3) Inserted this at the top of my CSS code for the whole form (replacing .form-radio-item with the real ID)
It's still not working. What am I doing wrong?
- BurkhartAnswered on July 31, 2015 at 08:27 AM
This is what my results are, and I would like a space in between Yes, No and Maybe.
- JotForm SupportdavidAnswered on July 31, 2015 at 12:03 PM
CSS will not have any impact on how your data is entered in the spreadsheet. CSS only applies to the form itself, not the results. Since the results are collected in the same field, they will be entered in the spreadsheet as a single entry. There is, unfortunately, nothing we can do about the formatting on our end. This is how to the data is forwarded to the spreadsheet.
- BurkhartAnswered on July 31, 2015 at 10:04 PM
Ok, thanks! I can create a formula in excel once in it. Just wondered if there was a way to make it happen before then.
- grade4pagasaAnswered on August 01, 2015 at 12:55 AM
Randy here, fellow JotForm user.
disclaimer: i may not have visualized the whole picture correctly (i don't have enough for reference or context). this suggestion is based on the screenshot you provided and on the answer David supplied.
i piggybacked on the idea JotForm Support David said. i tried manipulating the Output field within the form itself via the Form Calculation widget by inserting a single space between each field (fig. 1). you have the option to Hide the intermediate-output-field if needed.
i also tried it on 2 scenarios: regular checkbox fields and matrix with checkbox as input (fig. 2). you can see the text output (in the format you want) from a single text-field in figures 2, 3 & 4.
hope this helps.
fig. 1 (form calculation wizard)
fig. 2 (form)
fig. 3 (submissions page)
fig. 4 (downloaded excel file)
- BorisAnswered on August 01, 2015 at 06:25 AM
Yes, that is a very nice workaround, Randy. :)
However, I believe that our user Burkhart is looking at multiple answers to only one regular Check Box field. The workaround is great for multiple Check Box fields, but on one it displays results separated by a comma.
Based on my testing without any workarounds, the answers to one Check Box field seem to be displayed on their separate lines for me, in the same cell.
I hope this helps.