0

How to insert a "carriage return" in a formula?

Hi all.

In a "Customer" database, based on a YouTube video, I created a formula field that contains street address + City + Province.

I would like to have this "formatted";  in other words, street on one line, City and Province on another line, etc.

Is there a way to insert a "carriage return" in the formula?

Is this the way to achieve what I want?

Thanks.

3replies Oldest first
  • Oldest first
  • Newest first
  • Active threads
  • Popular
    • Birger H
    • Birger_H
    • 4 yrs ago
    • Official response
    • Reported - view

    Try it like this:

    –––
    street + "
    " + City + " " + Province
    –––

    In other words: you add a carriage return ba giving a carriage return in quotation marks. 

    Birger

    Like 1
      • Admin
      • Admin.7
      • 6 mths ago
      • Reported - view

      Birger H was really simple at the end ! thanks for the solution !

      Like
    • Frederico R
    • C90Go!
    • Frederico_R
    • 3 yrs ago
    • Reported - view

    Please note: Your Formula will return 'undefined' until you 'Save Changes', at which point the new text formatting will appear. Lots of trial and error discovering this one.

    Like
Like Follow
  • Status Answered
  • 6 mths agoLast active
  • 3Replies
  • 2722Views
  • 1 Following