Forum Discussion

KallieGoodwin's avatar
KallieGoodwin
Qrew Trainee
8 years ago

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 ...
MCFNeil's avatar
MCFNeil
Qrew Captain
8 years ago
Are they date fields?  what type of 'data' is being compared?

The formula would most likely be a formula-checkbox.

Call it "Data Doesn't Match";
If([Parent Lookup Field]=[Child Data Field], false, true)

But I'm sure you need to account for when either data point is blank (because if one or the other is blank, then they wont match.  And you don't need those on the report, or you might).

If([Parent Lookup Field]="", false,
If([Child Data Field]="", false,
If([Parent Lookup Field]=[Child Data Field], false, true)))