Forum Discussion

PaulPeterson1's avatar
PaulPeterson1
Qrew Assistant Captain
5 years ago

Pipeline Create New Record, only if it does not exist?

Honestly, I haven't dug deeply into this question yet.  Is it possible to use a pipeline to create a new project only if that project number does not exist? ------------------------------ Paul Pet...
Pipelines
MarkShnier__You's avatar
MarkShnier__You
Icon for Qrew Legend rankQrew Legend
5 years ago
The Method I suggested above is actually designed specifically to work for the situation where where the project number is not the key to the Table 2.

------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
CraigMcElroy's avatar
CraigMcElroy
Qrew Member
4 years ago
I have a similar situation where I want to add records in a destination table if they do not already exist.  But, the source could be any of... say... 20 different tables.  So, I do not want to build a complex web of relationships to all of the different source tables.  Instead, I would rather build a Pipeline to search the destination table if the record exists and add if it does not exist.  Since these tables are updated in bulk, I do not think I can use a trigger of when a record is created.  And, I want to avoid hundreds of errors by building an add without first checking for existing.

Do you have any thoughts for a solution to what I am suggesting?

------------------------------
Craig McElroy
------------------------------