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 ...
Wizards and add-ons
  • MikeKlausing's avatar
    MikeKlausing
    5 years ago

    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
    ------------------------------
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
5 years ago

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