Forum Discussion

GeorgeBramhall2's avatar
GeorgeBramhall2
Qrew Cadet
6 years ago

Button to change status of a field on the record ,but ask user first if he/she is sure...

What does the url formula look like for a button on a record in an embedded report that when clicked changes the status of the record to approved, but before that it asks the user if he/she is sure th...
Formulas and functions
MarkShnier__You's avatar
MarkShnier__You
Icon for Qrew Legend rankQrew Legend
6 years ago
The low tech solution is to have a button which redisplays the record on a super mini form that asks asks are you sure.  The user will have two buttons,

One will be "Beam me up Scotty - get me outta here", and take the user back to the original form. 
The 2nd button will in fact do the update and land the user back on the record on the full form.

------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
  • BradLemke's avatar
    BradLemke
    Qrew Assistant Captain
    6 years ago
    Brief note:  This is a Rich Text Formula field on an embedded dashboard report, which is why I have it set to redirect to the dashboard once clicked.  Play around with this and see how it works out for you.

    "<a class='Vibrant Alert' style=\"width:150px; text-align: center;\" href=\"javascript:if(confirm ('CUSTOM POPUP MESSAGE')){location.assign('/db/" & Dbid() & "?act=API_EditRecord&rid=" & [RECORD ID] & "&_fid_X=X" & "&_fid_X=" & (X) & "&rdr=" &
    URLEncode(URLRoot() & "db/" & Dbid() & "") & "')}\">CUSTOM BUTTON TEXT</a>"

    ------------------------------
    Brad Lemke
    ------------------------------