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....
MarkShnier__You's avatar
MarkShnier__You
Icon for Qrew Legend rankQrew Legend
3 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'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
------------------------------