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 withCONCATENATE([FIELD1),"_",[FIELD2])but that doesn't seem to work. Getting this error: Formula error -- Unknown functionThe function name Concatenate(text, text, text) is unknown.Really? You can't use CONCATENATE in Quickbase? Any advice? Thanks!

If you need to test for a value in Field2:If([FIELD2]="",[FIELD1],[FIELD1]&"_"&[FIELD2])

The function does not exist however you can make it happen:[FIELD1]&"_"&[FIELD2]

Also considerList("_", [field 1], [field 2])It does the concatenation and has the advantage that when contact enacting multiple fields ( as many as you like) it will only insert your desired separator between non null values .

Thanks so much. I'll try these out. They both look like they will work for what I need.

Can I use concatenate in Quickbase?

DavidHawe
Qrew Trainee
12 years ago
If you need to test for a value in Field2:

If([FIELD2]="",[FIELD1],[FIELD1]&"_"&[FIELD2])
- BlancaAnderson
  Qrew Assistant Captain
  6 years ago
  David,
  
  If we needed to concatenate only if the checkbox is checked? How would this formula look? I have a table with services offered and several checkboxes listing each service. I would like one fields to have a list.
- QuickBaseCoachD
  Qrew Captain
  6 years ago
  List(", ",
  IF([Wash checkbox], "Wash"),
  IF([Dry checkbox], "Dry"),
  IF([Iron checkbox], "Iron"),
  IF([Repair checkbox], "Repair")
  )
- DavidHawe
  Qrew Trainee
  6 years ago
  What he said: ^^
DavidHawe
Qrew Trainee
12 years ago
The function does not exist however you can make it happen:

[FIELD1]&"_"&[FIELD2]
MarkShnier
Qrew Cadet
12 years ago
Also consider

List("_", [field 1], [field 2])

It does the concatenation and has the advantage that when contact enacting multiple fields ( as many as you like) it will only insert your desired separator between non null values .
DavidHawe
Qrew Trainee
12 years ago
I always forget about List
KevinGullickson
Qrew Trainee
12 years ago
Thanks so much. I'll try these out. They both look like they will work for what I need.
ArchiveUser
Qrew Captain
11 years ago
I found this by accident and it's exactly what I need for my next app. Thank you very much.
ArchiveUser
Qrew Captain
10 years ago
could somebody please guide me through, how do we implement [FIELD1]&"_"&[FIELD2], i have two tables "Trainings and Students" each student can take many trainings and each training can have many students, that means we are dealing with a many to many relationship, so i want the same student not to take the same training more than once, i need help in this, email: smuslim@radp-s.com
QuickBaseCoachD
Qrew Captain
10 years ago
You will need to post this as a new question in order for it to get answered.
ArchiveUser
Qrew Captain
10 years ago
Both of these options are causing my application to crash :(
ArchiveUser
Qrew Captain
10 years ago
what do you mean by crashing, could you please further clarify it, since i used it and it works fine.

Forum Discussion

Can I use concatenate in Quickbase?