Question

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

13 years ago
Nov 3, 2012 8:42 PM UTC
0 replies
55 views

JimJim2
Registered

I have name, street, city, state, zip in separate fields. would like to have a multi line field that combines them

This topic has been closed for replies.

anomDiebolt
Registered
13 years ago
Nov 3, 2012 8:56 PM UTC

Create a text formula field and use a newline character in the formula:

[First] & " " & [Last] & "\n" &
[Address] & "\n" &
[City] & ", " & [State] & " " & [ZipCode]

Like

A

ArchiveUser
Registered
13 years ago
Nov 4, 2012 7:26 AM UTC

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