ContributionsMost RecentMost LikesSolutionsRe: Concatenate two fields in the same table.Yes, I did figure that out. My problem now is that I need to remove those "-". Any ideas?Re: Concatenate two fields in the same table.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?Concatenate two fields in the same table.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) Re: Comparing two fields in different tables to produce a out come in a third table.No, not Telecom. But I see why you're asking many of the threads I've read similar to my question have been in that field. It will be for auditing purposes, and right now it's on a few thousand records strictly to just compare what they have versus what we have. I have it set up now with my source as my parent table in a relationship with our records as the child table. And I have the look up fields set (or a few for now). The more I think about, the more I think the third table is not needed. But I am still stuck on writing the formula to compare the fields and print that the fields don't match.Comparing two fields in different tables to produce a out come in a third table.I need to compare what our records have versus the records of a third party. I get the third party records as a excel/csv and import into a table in my Quickbase app. I want to look at Field 1 in our records and compare it to the corresponding or similar field in the other table with the third party records. I am not sure how to start to go about doing this; but my thought is to have three tables total 1) our records, 2) third party records 3) results from the comparison. These three tables would have relationships created between them. I am new to Quickbase and not experienced with writing formulas so I need some help here, but this is my thought process on how to accomplish this: Table 3 field to compare - CompareFields (formula-text) Formula: If(unique ID = unique ID, Then( If [Field 1 from table 1] != [Field 1 from other table] "Mismatch")) Obviously this is not the correct way to write the formula... suggestions!? Would a Quickbase API be something I should try?