How do I add a button to show up on each record that creates a new record in another table and copies data from the original table?

Could you please elaborate a little more. I have the same desire.

I have a table that I need to update on a frequent basis. I hope building report in Quickbase would save me time to do pivot table at each update. The update involves change in records and column value. I already built my reports in Quickbase, and would like to find a way to update the table, so the reports can be updated accordingly.