Rich text with Google Sheet integration

  • Profile Image
    yantiang
    Asked on March 08, 2016 at 06:16 AM

    I made a form with a rich text field and integrated it with a Google Sheet.

    Looking at the Google Sheet, the formatted text has been stripped of all mark-up ends up in the cell as bare plain text. 

    I tried this with both CK Editor and Tiny MCE. 

    To check I also added a Text Box and typed "<p>this is <strong>bold</strong></p>". The result is the same - the text appears in the Google Sheet stripped of all the mark-up.

    One final point: I note that the "Edit Submission" field that is now a feature of every form, does appear as html on the Google Sheet.

    Question is why does this happen and is there a way to around it.

     

    Thanks

  • Profile Image
    beril
    Answered on March 08, 2016 at 11:09 AM

    If I understand your question correctly, even if you use bold text on your rich text field, it doesn't seem bold in the Google Spreadsheets Integration. Unfortunately, it is not possible with JotForm. However, you can do it manually in your spreadsheet as you see below:

    If you have any question or issues, please do not hesitate contacting us. We will be glad to assist you.

  • Profile Image
    yantiang
    Answered on March 08, 2016 at 12:45 PM
    Thanks for your prompt reply. It is self-evident that it does not work with JotForm. Would the developers be able/willing to change this behaviour as I see it as a bug. If I for example use a Google form and submit via a plain text field “bold” then that is exactly how it appears in a cell on the Google Sheet. But if I do exactly the same using JotForm using a plain text filed then all the mark-up gets stripped-out by the integration. I know that marked-up text can be entered manually directly into the Google Sheet but that is of no practical use if I am using a form to submit the data.
    ...
  • Profile Image
    BJoanna
    Answered on March 08, 2016 at 03:15 PM

    I have integrated my test form with Google Spreadsheets and I set two of the columns to show submitted data as “bold”. Then I have made another submission and new data are also "bold". 

    I would suggest you to re-integrate your form with Google Spreadsheets to see if that will resolve your issue. 

    1. Remove the current integration

    2. Clear your JotForm cache

    3. Re-integrate with Google Sheets

    Hope this will help. Let us know if you need further assistance.

  • Profile Image
    yantiang
    Answered on March 08, 2016 at 03:46 PM
    Thank you, but that is not the problem. Of course if you set the column to bold everything in that column will be bold. The problem is that text formated as rich text in JotForm will have all the mark-up stripped out when sent to a Google Spreadsheet using the integration. That means bold, italic, list etc all revert to plain unformatted text. This appears to be a bug in the integration. Google Spreadsheet cells do support HTML and in fact you can enter HTML in a cell either manually or by posting rich text from a Google Form or via Zapier etc - none of which is of any help to me.
    The information contained in this email is confidential.
    If you are not the intended recipient, any disclosure, copying or distribution is prohibited. Please inform the sender that you have received the email in error and then delete it from your system. World ORT cannot take responsibility for the accuracy or completeness of this email as it has been transmitted over a public network. If you suspect that the email has been intercepted or amended or it is incomplete, please notify the sender.
    ...
  • Profile Image
    Chriistian
    Answered on March 08, 2016 at 10:21 PM

    Currently the form data does indeed get sent without any formatting to the google spreadsheet when using the integration. If you like, we can send this as a feature request on your behalf so that the integration sends the data in rich text format to google sheets. However, do note that the implementation depends on the amount of users requesting the feature and the workload of our developers.

    Do let us know if you approve so we can proceed.
    We will wait for your reply.

  • Profile Image
    yantiang
    Answered on March 09, 2016 at 05:45 AM
    Thank you. Understood, but this is surely a bug not a feature.
    ...