Forum Discussion

BrittanyScheid's avatar
BrittanyScheid
Qrew Cadet
4 years ago

Re: Formula URL button - save and redirect

Thank Sharon. I tried this, but it's still just sending me back to the same page after it goes to the code page. I tried sending it to the form that I want and also just to the app home page and neither worked. Both times it just went back to the same edit form screen.  Any thoughts? Below is the code from the formula-URL field.  I used the code directly from the code page Body on this page without any changes.

var text rid = 
    If([Record ID#]>0,
        ToText([Record ID#]), // Record ID already exists
        "%%rid%%" // New record, no Record ID exists yet
    )
;

// API URL to Add/Edit/etc.
var text urlToExecute = URLRoot() & "db/" & Dbid() & "?a=er&dfid=12&rid=" & $rid;

//& Dbid() & "?a=er&dfid=12&rid=" & $rid;

URLRoot() & "db/" & AppID() & "?a=dbpage&pageid=4" // Open code page 4
& "&url=" & urlencode($urlToExecute) // Pass in the URL to execute​


------------------------------
Brittany Scheid
Special Projects Manager
SimiTree
------------------------------

4 Replies

  • QuickBaseJunkie's avatar
    QuickBaseJunkie
    Icon for Qrew Legend rankQrew Legend
    4 years ago
    @Brittany Scheid Ahhhh, I missed that in my last reply.​

    On the code page, update this line of text:

    window.location.href = document.referrer;

    to

    window.location.href = document.referrer + '&dfid=12';

    assuming your form id is 12

    Please note, this will render the code page less versatile for multiple uses since it will be hard coded to return to this specific form. But this is the simplest way to achive your goal.

    -Sharon

    ------------------------------
    Quick Base Junkie
    Quick Base Junkie
    https://quickbasejunkie.com
    ------------------------------
    • BrittanyScheid's avatar
      BrittanyScheid
      Qrew Cadet
      4 years ago
      So that got me to the right form, but because the starting page is adding a new record, it pulled up the correct form, but for adding a new record. Is there any way to get it to save that new record, go to the pause code page, then redirect to form ID 12 for that record that was just ssaved?

      ------------------------------
      Brittany Scheid
      Special Projects Manager
      SimiTree
      ------------------------------
      • QuickBaseJunkie's avatar
        QuickBaseJunkie
        Icon for Qrew Legend rankQrew Legend
        4 years ago
        @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
        ------------------------------