Forum Discussion

BarryDolan's avatar
BarryDolan
Qrew Cadet
2 years ago

Create static text in a multi line text field from a selection in a multiple choice field

I am hoping I can get suggestions on how to take a value from a multiple choice field and insert it on a multi-line text field, without it changing when the value changes in the multiple choice field....
BarryDolan's avatar
BarryDolan
Qrew Cadet
Thanks, Mark. This is more in line with what I'm looking for. I believe it will work if I can just figure out how to get rid of the HTML code. I have no clue why it's doing this.
Please see example.

------------------------------
Barry Dolan
------------------------------
MarkShnier__You's avatar
MarkShnier__You
Icon for Qrew Legend rankQrew Legend
2 years ago
Is the call notes field a Rich Text field type?  That would cause the HTML.   Can you make it just a text field type?  Or multi line text field type?

------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------
  • BarryDolan's avatar
    BarryDolan
    Qrew Cadet
    2 years ago
    It started as a rich text and I changed it, thinking it might be the issue. Maybe I should delete it and add a new field and see if that corrects it. 

    Do you see anything wrong with the formula?
    [Communication Type] & ": " & [Call Notes]

    ------------------------------
    Barry Dolan
    ------------------------------
    • MarkShnier__You's avatar
      MarkShnier__You
      Icon for Qrew Legend rankQrew Legend
      2 years ago
      Yes, try with a new clean field.  The formula is fine.

      ------------------------------
      Mark Shnier (Your Quickbase Coach)
      mark.shnier@gmail.com
      ------------------------------
      • BarryDolan's avatar
        BarryDolan
        Qrew Cadet
        2 years ago
        That didn't make a difference, still inserted the HTML code.

        ------------------------------
        Barry Dolan
        ------------------------------