Skip to main content
Question

Can I use concatenate in Quickbase?

  • June 4, 2019
  • 0 replies
  • 241 views
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 be "v2". I just want to combine them to be "Diabetes_v2" in the new field. Is that possible? Seems like if should be simple enough with

CONCATENATE([FIELD1),"_",[FIELD2])

but that doesn't seem to work. Getting this error: 

Formula error -- Unknown function
The function name Concatenate(text, text, text) is unknown.

Really? You can't use CONCATENATE in Quickbase? Any advice? Thanks!

------------------------------
Test Member
First time builder and on the path to certification.
------------------------------
    This topic has been closed for replies.

    • SeanPadian
    • Quickbase Staff
    • October 3, 2019
    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
    ------------------------------
    Terms & ConditionsAccessibility statement