Skip to main content
Question

Concatenate two fields in the same table.

  • October 5, 2017
  • 0 replies
  • 69 views
I am trying to make a unique number to use in a comparison project. To do this, I need to concatenate two fields that are already in my table. Both fields are Text field types.

This is what I have now, but it is cutting the concatenation off. 

ToText([Tax ID]) &Right(ToText([Tax Number]),100)

 
    This topic has been closed for replies.

    • MCFNeil
    • Quickbase Alumni
    • October 5, 2017
    Try just a List formula:

    List("-", [Tax ID], [Tax Number])

    It makes it easier to control. 

    May I ask why you wanted to take the last 100 characters?
    • KallieGoodwin
    • Author
    • Quickbase Alumni
    • October 5, 2017
    Thanks for the recommendation. 

    The 100 last characters was just me troubleshooting why it wasn't working. 

    The formula you suggested is only taking part of the tax ID and none of the tax number, i.e.: 
    Tax ID: 00-783-000-000
    Tax  Number: 547
    The result is only giving me 783 

    Or
    Tax ID: 11720-000-000
    Tax Number: 5698
    The result: 11720 

    How do I make it print the entire two sets of data? Regardless of the leading or ending 0's?

    I should add, the formula field type I have selected is Numeric, but my two fields I am trying to concatenate are text. Does that make a difference? 
    • ChrisChris
    • Quickbase Alumni
    • October 5, 2017
    You may have discovered this by now, but the formula has to be text to incorporate the hyphens.
    • KallieGoodwin
    • Author
    • Quickbase Alumni
    • October 5, 2017
    Yes, I did figure that out. 

    My problem now is that I need to remove those "-". Any ideas? 
    Terms & ConditionsAccessibility statement