KallieGoodwin
8 years agoQrew Trainee
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?
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?