Forum Discussion

JordanMcAlister's avatar
JordanMcAlister
Qrew Captain
5 years ago
Solved

Multi-line text field on an exact form

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
------------------------------
  • 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

     



    ------Original Message------

    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 Replies

  • MikeKlausing's avatar
    MikeKlausing
    Qrew Assistant Captain

    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

     



    ------Original Message------

    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
    ------------------------------
    • JordanMcAlister's avatar
      JordanMcAlister
      Qrew Captain

      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
      ------------------------------