Forum Discussion

Qrew Captain

6 years ago

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

"" &
"" &

(List
(" ",
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]))

& ""
& ""

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

"" &
"" &

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

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

// substitute new line for semicolon
SearchAndReplace($RemoveSpaceAfterSemiColon,";"," ")

& ""
& ""

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

Qrew Assistant Captain

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

"" &

"" &

(List

(" ",

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

& ""

& ""

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

"" &

"" &

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

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

// substitute new line for semicolon

SearchAndReplace($RemoveSpaceAfterSemiColon,";"," ")

& ""

& ""

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

Qrew Captain

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