Forum Discussion

BarryDolan's avatar
BarryDolan
Qrew Cadet
3 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
3 years ago
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
3 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
    3 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
      3 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
        3 years ago
        That didn't make a difference, still inserted the HTML code.

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