HAVE AN AUTOMATED NUMBER FIELD WITH A UNIQUE NUMBER FOR EACH RECORD, AND ANOTHER TEXT FIELD FOR LAST NAME. COMBINE THE TWO INTO ONE RECORD ID FIELD THAT CONTAINS THE NUMBER AND THE LAST NAME FOR EASIER IDENTIFICATION. I AM NEW TO THIS AND DID NOT SEE ANYTHING EXPLAINING WHETHER THIS COULD BE DONE IN THE KNOWLEDGEBASE
Anonymous shared this idea · Nov 1, 2014
Comments
1 comment
Hello,
The calculated text field would use a concatenate() function of the two fields you wish to combine. In the formula text area, the concatenation would look something like this {Numeric Field} & {Text Field}. This function will combine the two fields together- "12" & "Jones" becomes "12Jones" using the & to concatenate. If you wish to space them apart, a space can be concatenated in between the fields (the space would be between the quotes here):
{Numeric Field} & " "&{Text Field}
Additional information can be found in our KB article here: http://help.trackvia.com/knowledgebase/articles/281151-text-functions
Regards,
Alex
Please sign in to leave a comment.