Can I use concatenate in Quickbase?
Trying to combine two text fields in Quickbase into one text field. Field 1 is a title from another table and Field 2 is the version of that title. So Field 1 might be "Diabetes" and Field 2 might ...
Forum Discussion
Hi Test Member,
Yes, you can certainly concatenate fields in QuickBase using our formula language. In your formula, simply use the ampersand ("&") in between two fields in brackets to bring them together for display purposes.
[Field 1] & [Field 2]
This example has a field type of Formula-Text, and a 'Best Practice' is to use spaces to separate your two fields for a end-user better experience.
[Field 1] " & " [Field 2]
Hope this helps!
------------------------------
Sean Padian
------------------------------
Yes, you can certainly concatenate fields in QuickBase using our formula language. In your formula, simply use the ampersand ("&") in between two fields in brackets to bring them together for display purposes.
[Field 1] & [Field 2]
This example has a field type of Formula-Text, and a 'Best Practice' is to use spaces to separate your two fields for a end-user better experience.
[Field 1] " & " [Field 2]
Hope this helps!
------------------------------
Sean Padian
------------------------------
- [Field 1] & " " & [Field 2]
That will put a single space in the middle of both fields. You didn't list that formula and only spoke about it so I figured it cannot hurt to put in there.- QuickBase uses the List function.
List("_", [field1], [field2])
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
markshnier2@gmail.com
------------------------------
