Bug Fixing for Checkboxes.
The way checkboxes are managed now is not satisfactory.
Google Sheet puts a Coma and a Space between different answers.
Example= answera, answerb, answerc, answerd, answere, ..., and so on
Form Publisher (I do not know why) just eliminates the space. I think this is a BUG.
Consequently, the result in my merged template looks like a very long word. Totally unreadable.
Example= answera,answerb,answerc,answerd,answere,..., and so on.
Can you see what I mean?
Maybe the solution is easy on this one.
In addition, this user had a very good idea:
Of course, I would love to choose how to format checkboxes, but - at the very least - restore the missing "space" character between different answers is very important.
I also tried few workarounds:
1- Adding a space after an option in Google Form --> not working.
(The ending space is automatically removed).
2- Adding a space before an option in Google From --> not working.
(The initial space is automatically removed).
3- Using “Importrange” function to fix the problem --> not working.
(Importrange function only works if access to data is allowed, I there is not a way to automatically allow for each new merged document created with form publisher).
Best regards and thank you for your very appreciated effort!
This has since been solved!
- - - WORKAROUND - - -
It is very simple, actually - - -> Use the SPLIT function.
1) Go to the first empty column of your Form Response Sheet.
Example = Col E
2) In the first row (E1) put the following function:
where A1 is the column where the responses of your checkbox are recorded.
3) Now you will have the content of cell A1 divided in various cells.
The number of cells depends on the number of options checked by the user in his response. Now you can also create bullet points!
4) You can then combine these cells again.
Example =B1&” “&C1” “&D1 will add a space and a coma between the cells.