Forum Discussion

MeganHardison's avatar
MeganHardison
Qrew Member
5 years ago

Exact Forms printing Multi-line text field

Hi guys,
We have a multi-line text field that we type several things down in a row. For example:

1 - of this item
1 - of another item
2 - of this item

But when we print it out of EF, it will put it in a paragraph, like this:

1 - of this item 1 - of another item 2 - of this item. It ignores the returns. How do I fix this?

------------------------------
Megan Hardison
------------------------------
Tables and fields
Wizards and add-ons
  • BlakeHarrison's avatar
    BlakeHarrison
    Qrew Captain
    5 years ago
    Unfortunately, you'll need to do one of two things. Either convert the field to a Rich Text field OR create a Formula Rich Text field that can take the original field and insert the proper HTML in place of the current line breaks. Most likely, you'll need to use the SearchAndReplace function and look for the "<br>" (I think) and replace it with "<br />" or "<p />".

    ------------------------------
    Blake Harrison
    bharrison@datablender.io
    DataBlender - Quick Base Solution Provider
    Atlanta GA
    404.800.1702 / http://datablender.io/
    ------------------------------
    • MeganHardison's avatar
      MeganHardison
      Qrew Member
      5 years ago
      Okay cool. The field is named [Contents]. I can make a new Rich Text Formula field to pull whats in the [Contents] field, then show that field on the EF form? If so, can someone help me with the formula to use the SearchAndReplace?

      ------------------------------
      Megan Hardison
      ------------------------------
      • MeganHardison's avatar
        MeganHardison
        Qrew Member
        5 years ago
        Can anyone help me with this, or do you guys think it's something that can't be done?
        If it can't be done, I try something completely different.
        Thank you all!!!


        ------------------------------
        Megan Hardison
        ------------------------------