Discussions

 View Only
  • 1.  Dynamic Form Rule Not Copying Formula Text Correctly

    Posted 10-28-2020 11:24
    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:
    DOOR INSERT
    <char code="10">Insert Location:  
    <char code="10">Manufacturer:  RSL
    <char code="10">Design Name:  Bevel Cluster
    <char code="10">Size:  22x64
    <char code="10">Caming Color:  Brass
    <char code="10">Impact Rating:  Non-Impact
    <char code="10">Frame Type:  White</char></char></char></char></char></char></char>

    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:&nbsp;&nbsp;<BR><char code="10"/>Manufacturer:&nbsp; RSL<BR><char code="10"/>Design Name:&nbsp; Bevel Cluster<BR><char code="10"/>Size:&nbsp; 22x64<BR><char code="10"/>Caming Color:&nbsp; Brass<BR><char code="10"/>Impact Rating:&nbsp; Non-Impact<BR><char code="10"/>Frame Type:&nbsp; White

    ------------------------------
    Thanks,

    Bonnie
    ------------------------------


  • 2.  RE: Dynamic Form Rule Not Copying Formula Text Correctly

    Posted 10-28-2020 11:35
    Please note the description field did not show correctly above:

    Insert Description

    DOOR INSERT
    Insert Location:  
    Manufacturer:  RSL
    Design Name:  Bevel Cluster
    Size:  22x64
    Caming Color:  Brass
    Impact Rating:  Non-Impact
    Frame Type:  White

    ------------------------------
    Bonnie Durden
    ------------------------------



  • 3.  RE: Dynamic Form Rule Not Copying Formula Text Correctly

    Posted 10-28-2020 12:15
    Maybe try using an automation to see if it works any better.

    ------------------------------
    Mark Shnier (YQC)
    Quick Base Solution Provider
    Your Quick Base Coach
    http://QuickBaseCoach.com
    mark.shnier@gmail.com
    ------------------------------