Forum Discussion

HankHalverson's avatar
HankHalverson
Qrew Cadet
4 years ago

Text Field Combination

Hi everyone,
I am trying to combine two text fields and my code is not working. I am fairly sure that the flaw in the rich text code I have is in closing the code. I am no coding expert so any help is appreciated!

Here is my code:
List("\n",
List(" ", Part([First Name], 1, "\n"), Part([Last Name], 1, "\n"))


Thanks in advance,
Hank

------------------------------
Hank Halverson
------------------------------
Formulas and functions
  • MarkShnier__You's avatar
    MarkShnier__You
    Icon for Qrew Legend rankQrew Legend
    4 years ago
    Can you say in English what you're trying to do?

    ------------------------------
    Mark Shnier (YQC)
    mark.shnier@gmail.com
    ------------------------------
    • HankHalverson's avatar
      HankHalverson
      Qrew Cadet
      4 years ago
      My apologies, I wrote this discussion in haste. I was trying to take two text fields from a table and combine them on another text field using rich text. I found a similar code to the code I attached above and tried to tweak it to work on my stuff but could not figure it out. After posting the discussion I noticed I did not need the first line of that code and that is why it was not working.  So it works now, thankyou for taking the time to respond.

      ------------------------------
      Hank Halverson
      ------------------------------
      • JeffPeterson1's avatar
        JeffPeterson1
        Qrew Captain
        4 years ago
        You can just do this:

        [First Name]&" "&[Last Name]

        unless you're doing something more complicated.

        ------------------------------
        Jeff Peterson
        ------------------------------