Forum Discussion

JimJim2's avatar
JimJim2
Qrew Member
13 years ago

How do I create a multi line text field that brings in multiple fields

I have name, street, city, state, zip in separate fields. would like to have a multi line field that combines them
  • Create a text formula field and use a newline character in the formula:

    [First] & " " & [Last] & "\n" &
    [Address] & "\n" &
    [City] & ", " & [State] & " " & [ZipCode]
  • If you don't want to have extra spaces, new lines or commas when pieces of the data are missing, use:
    List("\n",
    [Name],
    [Street],
    List(" ", List(", ", [City], [State]),
    [Zip])
    )
    Hope that helps, Keira