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!