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!
------------------------------
Test Member
First time builder and on the path to certification.
------------------------------
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.
------------------------------
