If Then update button

Question

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
------------------------------

MarkShnierYou · Answer

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
------------------------------

Sign up

Login to the community