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....

MarkShnier__You

Icon for Qrew Legend rank

Qrew Legend

2 years ago

I suggest that you make a formula field which combines the Status with the call note.

then make a form rule

when the record is saved,
and any
[Status] has changed
[call note] has changed

ACTION
change the value of [My Logged field with status and call note] to the value in the field [status and call note formula]

------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------

BarryDolan
Qrew Cadet
2 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
  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
    ------------------------------