Skip to main content
Question

Can I use concatenate in Quickbase?

  • March 29, 2013
  • 0 replies
  • 1338 views
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!
This topic has been closed for replies.

  • DavidHawe
  • Registered
  • March 29, 2013
The function does not exist however you can make it happen:

[FIELD1]&"_"&[FIELD2]
  • DavidHawe
  • Registered
  • March 29, 2013
If you need to test for a value in Field2:

If([FIELD2]="",[FIELD1],[FIELD1]&"_"&[FIELD2])
    Forum|alt.badge.img+6
    • MarkShnier
    • Registered
    • March 29, 2013
    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
    • Registered
    • March 29, 2013
    I always forget about List
    Thanks so much.  I'll try these out.  They both look like they will work for what I need.
    • ArchiveUser
    • Registered
    • April 22, 2014
    I found this by accident and it's exactly what I need for my next app. Thank you very much.
    • ArchiveUser
    • Registered
    • June 1, 2015
    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
    You will need to post this as a new question in order for it to get answered.
    • ArchiveUser
    • Registered
    • October 7, 2015
    Both of these options are causing my application to crash :(
    • ArchiveUser
    • Registered
    • October 7, 2015
    what do you mean by crashing, could you please further clarify it, since i used it and it works fine.
    • ArchiveUser
    • Registered
    • October 7, 2015
    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
    ie, to see if the glitch is browser related.
    • ArchiveUser
    • Registered
    • October 7, 2015
    I tried Internet Explorer and had the same result.
    Try another browser?
    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
    • Registered
    • October 7, 2015
    great, how do you do that?
    At the top of the screen look for HELP, then Manage Support Cases.
    • ArchiveUser
    • Registered
    • October 7, 2015
    Is there a live support line I can contact?
    No, they will call you back or email you back.
    • ArchiveUser
    • Registered
    • October 7, 2015
    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.
    Terms & ConditionsAccessibility statement