JotForm is a free online form builder which helps you create online forms without writing a single line of code. No sign-up required.
We believe that if one user has a question, there could be more users who may have the same question. This is why many of our support forum threads are public and available to be searched and viewed. If you’d like help immediately, feel free to search for a similar question, or submit your question or concern.
Space in between results in checkbox field resultsAsked by Burkhart 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?
This is what my results are, and I would like a space in between Yes, No and Maybe.
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.
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.
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)
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.