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 records, even when there is no query. The Merge Field is set to the Record ID#, which was the only option to choose.
The pipeline structure is simple:
- Step A: Search a User table
- Step B: For each User found, copy the records from a Master table to a Child table.
Are there more steps to implement to use Copy records?
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.
