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...
Forum Discussion
MarkShnier__You
Qrew Legend
Qrew LegendThe 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
------------------------------
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
Sure,
List("-", [Field 1], [Field 2], [Field 3], [Field 4], ToText([Record ID#]))
------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------Is there a way to get the record ID to show between Field 3 and Field 4?
------------------------------
Derek Pipal
------------------------------
