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 they want to make the change. I am concerned that without the question to the user, the could click the button by accident and then correcting the problem becomes cumbersome for the user. #Formulasandfunctions

------------------------------
George Bramhall
------------------------------
​
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
      ------------------------------