Forum Discussion

DanMcLaughlin's avatar
DanMcLaughlin
Qrew Trainee
5 years ago

If Then update button

Hi

I am writing an app that has estimates.  I have a button that will create a clone of the working estimate but I need it to update  a field [is_active] to 0  (boolean)  so I don't have more that 1 active estimate.

here is the code I have now:
"javascript:void(copyMasterDetailButtonHandler('&relfids=27&copyFid=56&destrid=0&sourcerid=" & [Record ID#] & "', 'bqnffbzdf'))"

------------------------------
Dan McLaughlin
------------------------------
APIs and custom code
Buttons
  • MarkShnier__You's avatar
    MarkShnier__You
    Icon for Qrew Legend rankQrew Legend
    5 years ago
    The Copy Master Detail wizard button that you are using as well as the API equivalent will copy all fields.   But you can set up an Automation to detect when a record is added and the name begins with copy of, then set that field to unchecked.  So it would immediately get unchecked.

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