Skip to main content
Question

Check if record from one table exists in another.

  • April 13, 2021
  • 0 replies
  • 73 views
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
------------------------------
This topic has been closed for replies.

  • BlakeHarrison
  • Quickbase Alumni
  • April 13, 2021
Yes. You'll need the logic to go as follows:
  1. Search Table A
  2. For each record in Table A
    1. Search Table B where Email = a.email
    2. If Search List is Empty (delete the loop Pipelines automatically creates and just create a Condition)
      1. Create Record in Table C


------------------------------
Blake Harrison
bharrison@datablender.io
DataBlender - Quickbase Solution Provider
Atlanta GA
404.800.1702 / http://datablender.io/
------------------------------
Terms & ConditionsAccessibility statement