How to "copy" data captured in a single field to more than one multiple choice field in same table (can a pipeline do it?)
Hello! I am working on "performance management" app and have a form that captures "staff member" along with the staff member's "manager" in separate fields on a "phone call" form.
Next, we are capturing how many "errors" the staff member made on a phone call, thus I created SIX multiple-choice fields (error 1, error 2, etc.) to capture each error. I am stuck trying to associate "staff member" and "manager" to each error committed. We need to be able to summary report out on all errors, errors by staff member, and errors linked each manager.
I'm trying to link/copy the value of the staff member and manager captured 1x per form to each error made captured in error 1, error 2, etc.
A colleague suggested looking at the "bucket" channel in pipelines, but I am new to pipelines and cannot figure out how to make it do what I need. Bulk Record Set also doesn't seem to do the trick.
Am I on the right track looking at pipelines or is there another solution I am not seeing Thanks for any guidance!
------------------------------
Nelson Arce
------------------------------