Forum Discussion

AlanAlan1's avatar
AlanAlan1
Qrew Member
12 years ago

How to create a simple copy record button?

I would just like to create a simple button to add to my form to allow the user to copy the current record (but not the detail records)

I know this functionality exists from the drop-down menu, but I'm surprised that the advanced settings do not allow you to just choose the option to copy the current record without copying any of the detail records. I am trying to make it simple for users to copy records without having to choose a menu option. This functionality was a built-in button on the old QuickBase, but now it has been hidden under the "More" menu.

Thanks!
Forms
Relationships
Tables and fields
  • DavidHawe's avatar
    DavidHawe
    Qrew Trainee
    12 years ago
    You can make a Formula URL field:

    URLRoot()"&"db/{Table ID without brackets here}?a=GenCopyRecord&rid="&[Record ID#]
  • AlanAlan1's avatar
    AlanAlan1
    Qrew Member
    12 years ago
    I got it to work, but there was one extra " in there after the ()
    URLRoot()&"db/{Table ID without brackets here}?a=GenCopyRecord&rid="&[Record ID#]

    Thanks for your help!
  • ArchiveUser's avatar
    ArchiveUser
    Qrew Captain
    12 years ago
    In addition to this, what if i wanted to add the same record but more than once..... ?? Thanks!
  • ArchiveUser's avatar
    ArchiveUser
    Qrew Captain
    11 years ago
    Tried to add this used the following
    URLRoot()&"db/{bg474wsd4}?a=GenCopyRecord&rid="&[Down Hole ID#]

    get a There's nothing there message from QuickBase.  Any suggestions?
  • AJCampani's avatar
    AJCampani
    Qrew Cadet
    10 years ago
    I get the same message but I didn't leave the brackets in: URLRoot()&"db/biv72fmqy?a=GenCopyRecord&rid="&[Record ID#] - any ideas?
  • HeatherBryant's avatar
    HeatherBryant
    Qrew Member
    9 years ago
    Hi AJ, were you able to figure this out? I am getting the same error message you got. Thanks!

    EDIT: Nevermind. I pasted the wrong text. This worked for me.
  • marwankamal's avatar
    marwankamal
    Qrew Member
    8 years ago
    Hello, what if i want to delete the old record and keep only the new one?