Forum Discussion
- _anomDiebolt_Qrew EliteCreate a text formula field and use a newline character in the formula:
[First] & " " & [Last] & "\n" &
[Address] & "\n" &
[City] & ", " & [State] & " " & [ZipCode] - ArchiveUserQrew CaptainIf 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 - JimJim2Qrew MemberThanks, Just what I needed!
- CasameiraReyesQrew CadetHow do you collapse the space if it isn't filled?
- QuickBaseCoachDQrew CaptainDid you try the formula?
- JimJim2Qrew MemberThanks Keira