Forum Discussion

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

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

Qrew 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
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
  Qrew 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
    Qrew Cadet
    2 years ago
    That didn't make a difference, still inserted the HTML code.
    
    ------------------------------
    Barry Dolan
    ------------------------------