0

Formula to populate a multi-line text field

I'm looking to populate from separate field  the name, address1, address2, city, state, zip in a multi-line field that has the look of an envelope address. Yet, I can't find 2 things.

a) I can't find a way to put a formula into a multi-line text field

b) I can't find a way to trigger a new line in a formula that combines all the name, address, etc. fields.

Can you help me? Thanks

4 replies

null
    • Choices_Software_Dean
    • 4 yrs ago
    • Reported - view

    Place in a formular field:

     

    name + "

    " + address1 + "

    " + address2 + "

    " + city + ", " + state + " " + zip

    • Choices_Software_Dean
    • 4 yrs ago
    • Reported - view

    Our a button formular to populate the multi-line field:

    let v := name + "
    " + address1 + "
    " + address2 + "
    " + city + ", " + state + " " + zip;
    'Text (multiline)' := v

    • Luis
    • 4 yrs ago
    • Reported - view

    just a comment here.... because I was fighting with this for ages... :-) 

    this only works for "multi-line"... for Rich Text doesnt work.... (which seems to me strange as "Rich Text" is 'better' than Text???)

    • Choices_Software_Dean
    • 4 yrs ago
    • Reported - view

    To make it work for "Rich Text" use html in your button code, like this:

     

    let v := "<b>" + name + "</b><br>
    " + address1 + "<br>
    " + address2 + "<br>
    " + city + ", " + state + " " + zip;
    'rich text field' := html(v)

Login to reply

Content aside

  • 4 yrs agoLast active
  • 4Replies
  • 1133Views