Forum Discussion

SarahBurres's avatar
SarahBurres
Qrew Trainee
4 years ago

Copy Part of Record

I had a URL that would copy the entire record, but I am needing the button to only copy one section of the form.  Is there a way to do that?  

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


------------------------------
Sarah Burres
------------------------------
Buttons
  • MarkShnier__You's avatar
    MarkShnier__You
    Icon for Qrew Legend rankQrew Legend
    4 years ago
    Hi Sarah, you would need to make a formula URL button to Add a record and pre-populate certain fields. Post back if you need help with the syntax for that.

    ------------------------------
    Mark Shnier (YQC)
    Quick Base Solution Provider
    Your Quick Base Coach
    http://QuickBaseCoach.com
    mark.shnier@gmail.com
    ------------------------------
    • SarahBurres's avatar
      SarahBurres
      Qrew Trainee
      4 years ago
      Mark,
      Can you give a little more guidance please?  I'm not the strongest with URL Buttons. 


      ------------------------------
      Sarah Burres
      ------------------------------
      • MarkShnier__You's avatar
        MarkShnier__You
        Icon for Qrew Legend rankQrew Legend
        4 years ago
        np,
        The goal here is to put up an add record form with some of the fields filled in.

        Formula URL field

        URLRoot() & "db/" & dbid() & "?act=API_GenAddRecordForm
        & "&_fid_10=" & URLEncode([field name here])
        & "&_fid_11=" & URLEncode([field name here])
        & "&_fid_12=" & URLEncode([field name here])
        & "&_fid_13=" & URLEncode([field name here])


        You can get the field IDs form the Usage tab of the field or by right clicking the field name on the form in view mode of a record.

        ------------------------------
        Mark Shnier (YQC)
        Quick Base Solution Provider
        Your Quick Base Coach
        http://QuickBaseCoach.com
        mark.shnier@gmail.com
        ------------------------------