Forum Discussion

Qrew Member

2 years ago

Combining Text Listed in Fields

Hello, I have 4 text fields that I want to combine the data to make a unique name/code that goes into the Unique Name Field, what's the best way to do this? I basically want whatever is listed in t...

MarkShnier__You

Qrew Legend

The tidiest way is this.

List("-", [Field 1], [Field 2], [Field 3], [Field 4])

That will use a hyphen as a separator, but you can choose any character(s) in the quotes.

------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------

DerekPipal1

Qrew Member

2 years ago

Thanks Mark, that works well.

Is there a way to use the Record ID as well in this formula to have a Unique number?

------------------------------
Derek Pipal
------------------------------

MarkShnier__You
Qrew Legend
2 years ago
Sure,

List("-", [Field 1], [Field 2], [Field 3], [Field 4], ToText([Record ID#]))

------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------
- DerekPipal1
  Qrew Member
  2 years ago
  Is there a way to get the record ID to show between Field 3 and Field 4?
  
  ------------------------------
  Derek Pipal
  ------------------------------
  - MarkShnier__You
    Qrew Legend
    2 years ago
    List("-",
    
    [Field 1],
    
    [Field 2],
    
    [Field 3],
    
    ToText([Record ID#]),
    
    [Field 4])
    
    ------------------------------
    Mark Shnier (Your Quickbase Coach)
    mark.shnier@gmail.com
    ------------------------------