Skip to main content
Solved

Multi-line text field on an exact form

  • October 24, 2019
  • 0 replies
  • 161 views
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
------------------------------

Best answer by MikeKlausing

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
  • Registered
  • Answer
  • October 24, 2019

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
------------------------------
    Terms & ConditionsAccessibility statement