Forum Discussion

DerekPipal1's avatar
DerekPipal1
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 the 4 text fields to combine together into the Unique Name Field(currently formula field)

Thanks.



------------------------------
Derek Pipal
------------------------------
  • MarkShnier__You's avatar
    MarkShnier__You
    Icon for Qrew Legend rankQrew Legend
    2 years ago

    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's avatar
      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's avatar
        MarkShnier__You
        Icon for Qrew Legend rankQrew 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
        ------------------------------