Forum Discussion

BrianDunk's avatar
BrianDunk
Qrew Cadet
3 years ago

Link to Original Record After Copy

I am wondering if it is possible to add a link to a copied record back to the original record?  Here is what is happening...I currently have a copy record button that is working as expected.  See code for button below.  The issue is when I copy the original record I do not get any attachment field files.  Those types of fields are blank in the copied record which is not all bad because I don't want all the extra files if I can link back to the original where those files can be found if need be.

Copy Record Button:
"javascript:void(copyMasterDetailButtonHandler('&copyFid=19&destrid=0&sourcerid=" & [Budget item ID#] & "', 'bssz8m82p'))"

------------------------------
Brian Dunk
------------------------------
  • MarkShnier__You's avatar
    MarkShnier__You
    Icon for Qrew Legend rankQrew Legend
    3 years ago
    The copy master detail functionality does not allow you to control the population of any extra fields.

    But no problem. Create a process maintained by a Form Rule or a Pipeline that says when the record is saved and the field called [Original Record ID#] is blank, then copy the Record ID# into that field.

    And when you run the copy master detail that scalar field will get copied across.

    ------------------------------
    Mark Shnier (Your Quickbase Coach)
    mark.shnier@gmail.com
    ------------------------------
    • BrianDunk's avatar
      BrianDunk
      Qrew Cadet
      3 years ago
      Hi Mark, I am trying to create the form rule as you suggested.  The key field for the original record would be the key field "Budget Item ID#", however when I am in the form rule builder that field is not available for some reason.  

      I also tried creating a connection but I don't see the "Create a Conntection" button when I am in Connection Central.

      ------------------------------
      Brian Dunk
      ------------------------------
    • BrianDunk's avatar
      BrianDunk
      Qrew Cadet
      3 years ago
      Also, what do you mean by "scalar field"?

      ------------------------------
      Brian Dunk
      ------------------------------
      • MarkShnier__You's avatar
        MarkShnier__You
        Icon for Qrew Legend rankQrew Legend
        3 years ago
        The [Budget Item ID#] field should be a numeric field type, not a formula numeric field.  What type is is?

        Scalar is just a fancy word that I have heard Quickbase staff use, it just means a data entry field which is not a formula or a lookup field.

        ------------------------------
        Mark Shnier (Your Quickbase Coach)
        mark.shnier@gmail.com
        ------------------------------