Forum Discussion

Qrew Member

7 years ago

Find and append new unique values to secondary table

I have an app where I run a daily upload of data (much of it duplicate due to the nature of the source), but sometimes my daily upload includes a new record that needs to be added to a secondary table...

Data import and export

Qrew Captain

Did you manage to solve this problem?
I have similar one while using Automations.

What I want to do on a daily basis run automation to copy all not existing data in Table 2 from Table 1

------------------------------
Adam Krzyzanek
------------------------------

MarkShnier__You

Icon for Qrew Legend rank

Qrew Legend

5 years ago

I too am looking to so,be that same problem which is a feature needed in so many applications where we need to auto create parents. I'm hoping that there is a solution using Pipelines, but so far I have not been able to crack it.

------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------

DonLarson
Qrew Elite
5 years ago
If there is a way to do this with out scripts, I would love to see it. I am sure there would be many other uses.

------------------------------
Don Larson
Paasporter
Westlake OH
------------------------------
- AdamKrzyzanek
  Qrew Captain
  5 years ago
  @Evan Martinez - Maybe any solution for us?
  
  Please vote here:
  
  https://quickbase.uservoice.com/forums/111823-quick-base-product-feedback/suggestions/40015141-copy-unique-data-to-other-table
  
  @Don Larson, @Mark Shnier (YQC)
  
  ------------------------------
  Adam Krzyzanek
  ------------------------------
  - MarkShnier__You
    Qrew Legend
    5 years ago
    I gave it 3 votes. There are a couple of Pipeline Webinars coming up, plus another opportunity to learn more about Pipelines later in April. Maybe I will be smarter after I attend them :). But I'm concerned that even if there is a Pipelines solution it may be too "step intensive .. we will see.
    
    ------------------------------
    Mark Shnier (YQC)
    Quick Base Solution Provider
    Your Quick Base Coach
    http://QuickBaseCoach.com
    mark.shnier@gmail.com
    ------------------------------