Discussions

 View Only
  • 1.  Multi-line text field on an exact form

    Posted 10-24-2019 08:51
    Mulit-line text fields on an exact form don't keep their multiline structure. Anyone know how to fix this natively and not through exact forms plus? Using EF+ is outside of budget scope and is not up to me.

    How it appears in quickbase:
    -Hi, my name is John.
    -Hi, my name is Sara.
    -Hi, my name is Hector.

    How it appears on exact form:
    -Hi, my name is John. -Hi, my name is Sara. -Hi, my name is Hector.

    Thanks!

    #Forms


    ------------------------------
    Jordan McAlister
    ------------------------------


  • 2.  RE: Multi-line text field on an exact form
    Best Answer

    Posted 10-24-2019 09:18

    I had a similar issue but am using a rich text formula field to separate multiple fields in a vertical list. I do that with this formula:

     

    "<span style=\"font-size:11px;\">" &

    "<b>" &

     

    (List

    ("<br />",

    ToText(([Minimum Record ID# 1st sliding door - Sliding Door])),

    ToText([Minimum Record ID# 2nd sliding door - Sliding Door]),

    ToText([Minimum Record ID# 3rd sliding door - Sliding Door]),

    ToText([Minimum Record ID# 10th sliding door - Sliding Door]))

     

    & "</b>"

    & "</span>"

     

     

    I also have a combined text summary field that I separate into a vertical list with this formula:

     

    "<span style=\"font-size:11px;\">" &

    "<b>" &

     

    var text CombinedText = ToText([FIELD NAME]);

     

    var text RemoveSpaceAfterSemiColon = SearchAndReplace($CombinedText, "; ",";");

     

    // substitute new line for semicolon

    SearchAndReplace($RemoveSpaceAfterSemiColon,";","<br />")

     

    & "</b>"

    & "</span>"

     

    Thank you,
    Mike Klausing

     






  • 3.  RE: Multi-line text field on an exact form

    Posted 10-24-2019 10:09

    awesome, that worked perfectly!

    For anyone who needs my use case solution:

    "<span style=\"font-size:11px;\">" &
    "<b>" &
    
    var text CombinedText = ToText([POS Notes - Customer Instructions]);
    
    var text NewMultiline = SearchAndReplace($CombinedText,"-","<br />" & "-"); 
    
    $NewMultiline
    
    & "</b>"
    & "</span>"


    ------------------------------
    Jordan McAlister
    ------------------------------