BonnieDurden
5 years agoQrew Member
Dynamic Form Rule Not Copying Formula Text Correctly
I have a field that is a formula text field for an invoice item description using the "List" function (it takes all text from an item on the price sheet and combines it into one field). I have created a dynamic form rule to copy the information into another field so that my sales team can edit the text if need be, but when it copies I get all kinds of HTML code. Please note, the original formula field is not Rich Text, just regular text.
Here is what the fields look like and what I am getting when it copies the information:
Formula in Text Field
List("\n",
"DOOR INSERT",
"Insert Location: ",
"Manufacturer: " & [Manufacturer],
"Design Name: " & [Insert Price - Design],
"Size: " & [Insert Price - Size],
"Caming Color: " & [Insert Price - Caming Color],
"Impact Rating: " & [Insert Price - Impact Rating],
"Frame Type: " & [Insert Price - Frame Type])
How the Text Field Shows:
Here is what it is copying in the text field using the Dynamic Form Rule "Change" feature:
DOOR INSERT<BR><char code="10"/>Insert Location: <BR><char code="10"/>Manufacturer: RSL<BR><char code="10"/>Design Name: Bevel Cluster<BR><char code="10"/>Size: 22x64<BR><char code="10"/>Caming Color: Brass<BR><char code="10"/>Impact Rating: Non-Impact<BR><char code="10"/>Frame Type: White
------------------------------
Thanks,
Bonnie
------------------------------
Here is what the fields look like and what I am getting when it copies the information:
Formula in Text Field
List("\n",
"DOOR INSERT",
"Insert Location: ",
"Manufacturer: " & [Manufacturer],
"Design Name: " & [Insert Price - Design],
"Size: " & [Insert Price - Size],
"Caming Color: " & [Insert Price - Caming Color],
"Impact Rating: " & [Insert Price - Impact Rating],
"Frame Type: " & [Insert Price - Frame Type])
How the Text Field Shows:
DOOR INSERT
Insert Location:
Manufacturer: RSL
Design Name: Bevel Cluster
Size: 22x64
Caming Color: Brass
Impact Rating: Non-Impact
Frame Type: White
Here is what it is copying in the text field using the Dynamic Form Rule "Change" feature:
DOOR INSERT<BR><char code="10"/>Insert Location: <BR><char code="10"/>Manufacturer: RSL<BR><char code="10"/>Design Name: Bevel Cluster<BR><char code="10"/>Size: 22x64<BR><char code="10"/>Caming Color: Brass<BR><char code="10"/>Impact Rating: Non-Impact<BR><char code="10"/>Frame Type: White
------------------------------
Thanks,
Bonnie
------------------------------