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.
HTML tag appears in Google spreadsheetAsked by FridaHelena on May 08, 2015 at 04:04 AM
When I use checkbox in my form, I get <br> in my Google Docs spredsheet at submission. Is there a way to fix this?
I noticed this problem just a few days ago.
Could you show me exactly where you see those <br> elements?
I'll take a in depth look at it.
If I export all submissions there are no br-tags. But in my spreadsheet-integration they appear.
I've marked this as a bug and our developers will fix this issue. I'll update this thread once the problem has been resolved.
JotForm Support Manager
There are several widgets you could use instead, which do not create a line break tag <br> in the google spreadsheet.
I've created this form with 3 different check box widgets: Fancy Checkboxes, Minimal Checkbox, Square Checkbox
Here is how the spreadsheet looks like:
So I need to change my form because of this bug?
I cloned your form for troubleshooting purposes and then I integrate it with Google spreadsheet. The HTML tag <br> is not showing in the spreadsheet. Here's a screenshot:
The problem can be a cause by an extension or a plug-in that you've installed in your spreadsheet. Please try the following steps:
1. Remove the integration.
2. Logout from JotForm.
3. Clear your browser cache.
4. Close and re-open the browser.
5. Log back in to JotForm.
6. Add the Google spreadsheet integration.
In addition to that, I will clear your form cache so that your forms will be refreshed from our servers.
If the issue is still the same, then I would recommend you to try using the other checkbox widgets just like what Jeanette suggested.