Check if record from one table exists in another.

Question

Hello,I am working on application where are two tables (let's name them "A" and "B") with field "Email - work". I would like to prepare the report, for example based on new table "C", which will show how many emails existing in record "B" are missing in table "A".I am looking for solution without reorganizing the tables and creating master table for emails.Is it possible in pipelines to take all emails from table "B", then iterate through emails and check if in table A exists the record with this email, if not add record with that email to the "C" table?------------------------------Piotr Kryszkiewicz------------------------------

blakeharrison · Answer

Yes. You'll need the logic to go as follows:

Search Table A
For each record in Table A

Search Table B where Email = a.email
If Search List is Empty (delete the loop Pipelines automatically creates and just create a Condition)

Create Record in Table C

------------------------------Blake Harrisonbharrison@datablender.ioDataBlender - Quickbase Solution ProviderAtlanta GA404.800.1702 / http://datablender.io/------------------------------

piotrkryszkiewi · Answer

Thank you :)It works------------------------------Piotr Kryszkiewicz------------------------------

Forum Discussion

Check if record from one table exists in another.

Related Content

Nesting API Button Help (Add record and update another)

Moving Fields from One Table to Another

Custom Record Titles

Add Existing Child Records from New Parent Record

Using Grid Edit to Edit Multiple Records at Once