Getting Started

 View Only
  • 1.  Copy Master & Detail Records bottun

    Posted 03-09-2022 20:13
    Hi Everyone,
    I'm pretty new to QuickBase so I 'm not sure if this question is addressed somewhere else or not. I created a button to copy a record and it looks like the formula is working fine. I'm just wondering if there is any way to modify this formula?
    Basically, I would like to change the value of a specific field(the field is a Text - Multiple Choice) when I copy the record.  

    Copy Formula:
    "javascript:void(copyMasterDetailButtonHandler('&relfids=61,14&copyFid=6&destrid=0&sourcerid=" & [Opportunity #] & "', 'br74dayx8'))"


    ------------------------------
    Michael Naser
    ------------------------------


  • 2.  RE: Copy Master & Detail Records bottun

    Posted 03-09-2022 20:25
    No, that is not possible. But if you like you can create an Automation or a Pipeline to trigger on when a record is created the Copy Field name begins with the words Copy of. Then the Automation or Pipeline can set that Multiple choice field or any other fields that need changing or clearing.

    ------------------------------
    Mark Shnier (YQC)
    mark.shnier@gmail.com
    ------------------------------