Forum Discussion

QuickbaseAdmin1's avatar
QuickbaseAdmin1
Qrew Trainee
2 months ago

Copy Records Step - Skipping All Records

Hello, I am new to using the Copy Records step in Pipeline. I have a pipeline running with no errors but also creating no data. It's activity log reports that it skips all of the source table's rec...
  • MarkShnier__You's avatar
    2 months ago

    I believe that "HN" trying to use the pipeline QuickBase step called Copy Records.  As far as I can tell when Quickbase provided that step to us they kind of missed the mark on that one. The reason is they don't give us any opportunity to attach those copied records to any kind of Parent. So I really don't see the point of that step. 

    Don is suggesting that you search the template records and then in a For Each loop create your child records.  If  there's not that many child records then that's all there is to it.

    If you had a situation where there was a 50 or 100+ records then it would be kinder to the app and your users to create a bulk upsert and then add the rows into the bulk upsert and then commit the upsert.   That way the the processing takes place in the pipeline and doesn't slow down your app for your human users.