Creating a duplicate of the same record in Quick Base

  • 0
  • 1
  • Question
  • Updated 2 months ago
  • Answered
Hello,

I just wanted to ask if there is a functionality in Quick Base that allows creating of duplicate records.

For example, I have a table named 'Potential Team' and a record in the table is called 'Team.' Now, let's say Record#001 contains a thousand fields containing the names of different member (Member 1, Member 2..Member 999). Is there a way in Quick Base that allows me to re-create/copy the same record including all the data inputted in the fields? It would also be better if there is some sort of button/checkbox in the original record named "Copy record" that will trigger to create this duplicate.


Thank you for the help!
Photo of Paul Tria

Paul Tria

  • 102 Points 100 badge 2x thumb

Posted 2 months ago

  • 0
  • 1
Photo of Chris

Chris, Champion

  • 4,390 Points 4k badge 2x thumb

When you have the record open in view mode, your "More" menu at the top right will give you the option of copying the record.
(Edited)
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 53,570 Points 50k badge 2x thumb
The low tech way is that when viewing a record, as usual, the good stuff is hidden under the little "More ..." button at the top right.   One option is to copy the record.  You are in control of which fields copy forward, as this is a field property setting on every field type.  The default is to Copy.

If you want to make a button, you can make a formula URL button with this code

URLRoot() & "db/" & Dbid() & "?a=GenCopyRecord&rid=" & [Record ID#]

You can set it to appear as a button and chose a color.  I suggest only showing the button in View mode on the form.
Photo of Paul Tria

Paul Tria

  • 102 Points 100 badge 2x thumb
Thank you for the help sir!