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

26 Replies

Sort By
  • DavidHawe's avatar
    DavidHawe
    Qrew Trainee
    12 years ago
    If you need to test for a value in Field2:

    If([FIELD2]="",[FIELD1],[FIELD1]&"_"&[FIELD2])
    • BlancaAnderson's avatar
      BlancaAnderson
      Qrew Assistant Captain
      5 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's avatar
      QuickBaseCoachD
      Qrew Captain
      5 years ago
      List(", ",
      IF([Wash checkbox], "Wash"),
      IF([Dry checkbox], "Dry"),
      IF([Iron checkbox], "Iron"),
      IF([Repair checkbox], "Repair")
      )
  • DavidHawe's avatar
    DavidHawe
    Qrew Trainee
    12 years ago
    The function does not exist however you can make it happen:

    [FIELD1]&"_"&[FIELD2]
  • MarkShnier's avatar
    MarkShnier
    Qrew Trainee
    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 .
  • KevinGullickson's avatar
    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's avatar
    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's avatar
    ArchiveUser
    Qrew Captain
    9 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
  • ArchiveUser's avatar
    ArchiveUser
    Qrew Captain
    9 years ago
    what do you mean by crashing, could you please further clarify it, since i used it and it works fine.