Question

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

Forum|Forum|13 years ago
November 3, 2012
0 replies
43 views

JimJim2
Quickbase Alumni

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
Quickbase Alumni
Forum|Forum|13 years ago
November 3, 2012

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

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

Like

A

ArchiveUser
Quickbase Alumni
Forum|Forum|13 years ago
November 4, 2012

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