Forum Discussion

NelsonArce's avatar
NelsonArce
Qrew Member
2 years ago

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 capt...
MarkShnier__You's avatar
MarkShnier__You
Qrew Champion
Reporting on errors will be very difficult with that App design.

You should have a header record like you already have  and then a child table for errors.  Then all your reporting will be off the error child table.  You will lookup up any fields you need from the Header like the Team Member  and Manager and the date or whatever,  down to the child errors table so you have those fields for reporting.

------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------
NelsonArce's avatar
NelsonArce
Qrew Member
2 years ago
Brilliant! I understand exactly how to do that, many thanks for the knock on the head to see more clearly.

------------------------------
Nelson Arce
------------------------------