Discussions

Expand all | Collapse all

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

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

    Posted 01-06-2020 08:50
    Edited by George Bramhall 01-06-2020 08:51
    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
    ------------------------------


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

    Posted 01-06-2020 09:05
    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
    ------------------------------



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

    Posted 01-06-2020 09:39
    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
    ------------------------------