Forum Discussion

KevinGullickson's avatar
KevinGullickson
Qrew Trainee
12 years ago

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 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!
Formulas and functions
NotificationsEmail
Tables and fields
  • ArchiveUser's avatar
    ArchiveUser
    Qrew Captain
    10 years ago
    I put the formula List("_", [field 1], [field 2]) into the Formula field and hit save.  Then the page gets stuck in a "processing request" status until Chrome gives me the "the page has become unresponsive" error message
  • QuickBaseCoachD's avatar
    QuickBaseCoachD
    Qrew Captain
    10 years ago
    This is a very routine formula and in fact in working with QuickBase for almost 15 years I have never heard of that error.  I suggest that you put in a support ticket.
  • ArchiveUser's avatar
    ArchiveUser
    Qrew Captain
    10 years ago
    Just wanted to report back that this function worked fine in Firefox but not Chrome or IE.  Dangit Google, get it together.  Microsoft, you know that no one uses IE, just hang it up.