Formula URL button - save and redirect

@Brittany Scheid I had a sneaking feeling you might bring that up...

​​I really recommend The Button Masterclass so that these elements can be better understood.

Several additional changes will need to be made.

1. Change your field from a URL Formula to a Rich Text Formula.

2. Change the formula to something like this:

var text RID = If(IsNull([Record ID#]),"%%rid%%",ToText([Record ID#]));

var text urlToExecute = URLRoot() & "db/" & Dbid() & "?a=er&dfid=12&rid=";

var text URL = URLRoot() & "db/" & AppID() & "?a=dbpage&pageid=6" // Open code page 6
    & "&url=" & URLEncode($urlToExecute) & $RID ; // Pass in the URL to execute

var text LABEL = "Custom Save & Keep Working";

"<a class='Vibrant Success SaveBeforeNavigating' data-replaceRid=true href='" & $URL & "'>" & $LABEL & "</a>"​

3. Update the code page's errRdr function

    function errRdr(){
        let urlParams = new URLSearchParams(window.location.search);
        let url = urlParams.get('url');
        // Redirects to the previous page, if this page was the previous page as well, then redirect to the app home page
        if(document.referrer && document.referrer !== window.location.href) {
            window.location.href = url;
        }else{
            window.location.href = window.location.origin + window.location.pathname;
        }
    }​

CAUTION the use of the %%rid%% record id replacer will only work if an actual change is made to the new record before the button is pressed. (ie starting a new record and then immediately clicking the button will not force the record to save because there is nothing to save).

-Sharon

------------------------------
Quick Base Junkie
Quick Base Junkie
https://quickbasejunkie.com
------------------------------