Discussions

 View Only
  • 1.  Exact Forms printing Multi-line text field

    Posted 11-18-2020 10:03
    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
    ------------------------------


  • 2.  RE: Exact Forms printing Multi-line text field

    Posted 11-18-2020 15:41
    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/
    ------------------------------



  • 3.  RE: Exact Forms printing Multi-line text field

    Posted 11-19-2020 10:01
    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
    ------------------------------



  • 4.  RE: Exact Forms printing Multi-line text field

    Posted 12-01-2020 08:17
    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
    ------------------------------



  • 5.  RE: Exact Forms printing Multi-line text field

    Posted 12-01-2020 09:09
    try this

    SearchAndReplace([Multi line text field], "\n", "<br>")

    ------------------------------
    Mark Shnier (YQC)
    Quick Base Solution Provider
    Your Quick Base Coach
    http://QuickBaseCoach.com
    mark.shnier@gmail.com
    ------------------------------